Informatica_常用组件使用方法.docVIP

常用组件使用方法 表1中列出的是informatica中的所有组件。不会在本文档中出现的会在组件名后标出。 表1 Aggregator Active/ Connected Performs aggregate calculations. Application Source Qualifier Active/ Connected Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session. Custom Active or Passive/ Connected Calls a procedure in a shared library or DLL. Expression Passive/ Connected Calculates a value. External Procedure Passive/ Connected or Unconnected Calls a procedure in a shared library or in the COM layer of Windows. Filter Active/ Connected Filters data. HTTP Transformation Passive/Connected Connects to an HTTP server to read or update data. Input Passive/ Connected Defines mapplet input rows. Available in the Mapplet Designer. Java Active or Passive/ Connected Executes user logic coded in Java. The byte code for the user logic is stored in the repository. Joiner Active/ Connected Joins data from different databases or flat file systems. Lookup Passive/ Connected or Unconnected Looks up values. Normalizer Active/ Connected Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources. Output Passive/ Connected Defines mapplet output rows. Available in the Mapplet Designer. Rank Active/ Connected Limits records to a top or bottom range. Router Active/ Connected Routes data into multiple transformations based on group conditions. Sequence Generator Passive/ Connected Generates primary keys. Sorter Active/Connected Sorts data based on a sort key. Source Qualifier Active/ Connected Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session. SQL Active or Passive/Connected Executes SQL queries against a database. Stored Procedure Passive/ Connected or Unconnected Calls a stored procedure. Transaction Control Active/ Connected Defines com