1 / 7

Aggregator

Aggregator. Performs aggregate calculations Components of the Aggregator Transformation Aggregate expression Group by port Sorted Input option Aggregate cache Aggregate Functions AVG, COUNT, FIRST, LAST, MAX, MEDIAN, MIN, PERCENTILE, STDDEV, SUM, VARIANCE . Filter.

kiet
Download Presentation

Aggregator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Aggregator • Performs aggregate calculations • Components of the Aggregator Transformation • Aggregate expression • Group by port • Sorted Input option • Aggregate cache • Aggregate Functions AVG, COUNT, FIRST, LAST, MAX, MEDIAN, MIN, PERCENTILE, STDDEV, SUM, VARIANCE

  2. Filter • It provides the means for filtering rows in a mapping • All ports in a Filter transformation are input/output • Only rows that meet the condition pass through it • Cannot concatenate ports from more than one transformation into the Filter transformation • To maximize session performance, include the Filter transformation as close to the sources in the mapping as possible • Does not allow setting output default values

  3. Router • A Router transformation tests data for one or more conditions and gives the option to route rows of data that do not meet any of the conditions to a default output group • There are two types of output groups: • User-defined groups • Default group • Create one user-defined group for each condition that you want to specify

  4. Filter and Router – Compare

  5. Sequence Generator • Generates numeric values • It provides two output ports: NEXTVAL and CURRVAL • These ports can not be edited or deleted • Can not add ports to the sequence generator transformation • When NEXTVAL is connected to the input port of another transformation, the Informatica Server generates a sequence of numbers

  6. Stored Procedure Transformation • A Stored Procedure transformation is • an important tool for populating and maintaining databases • a precompiled collection of Transact-SQL statements and optional flow control statements, similar to an executable script • used to call a stored procedure • The stored procedure must exist in the database before creating a Stored Procedure transformation • One of the most useful features of stored procedures is the ability to send data to the stored procedure, and receive data from the stored procedure • There are three types of data that pass between the Informatica Server and the stored procedure: • Input/Output parameters - For many stored procedures, you provide a value and receive a value in return • Return values - Most databases provide a return value after running a stored procedure • Status codes - Status codes provide error handling for the Informatica Server during a session

  7. Sorter • A Sorter Transformation is used to sort Data. • Types of Sorting: • Ascending/Descending • Case Sensitive - Does Case sensitive ascending or descending sort. • Distinct - Gives distinctly sorted output rows. • A sorter can be used to sort data from a Relational Source or a Flat file. The Sort key has to be specified based on which the sort would be done.

More Related