Aggregator without any group by now pass all the ports ID,SAL,O_Count to aggregator t r and connect to next t r or tgt If you dont check any groupby port in aggregator bydefault it passes last record to the next transformation so here last record(O_count) contains max record number and also it our required count Any Queryes or sujessions @ chs sekhar@gmail com Cheers
Aggregator does not work properly - network. informatica. com Aggregator does not work properly We have faced issue with aggregator transformation (using sum on a field having 2 decimal values), and it truncates So we end up with difference of 0 01, compare to database simple SQL aggregation query for SUM()
Informatica Network Informatica by default uses cookies to enhance your user experience, improve the quality of our website, and deliver advertising and other content tailored to your interests
How to transfer all unique rows to 1 target and all . . . - Informatica Source-->SrcQualifier-->Aggregator(group by this column and find count also)--> then use joiner (use the column from Source qualifier and join the data from Aggregator as source qualifier col=aggregator col) --> Router (insert into t1 for count>1 and for count=1 insert into t2) t1 is for duplicate records and it will contain
i want to load employee details who are getting max and min sal from . . . Connect two aggregator transformations to the source qualifier Connect empno,sal,deptno to both the aggregators Group by deptno and get min and max sal in the respective aggregator Connect the output of both the aggregators to the union transformation
how to load half of the records into one table and remaining half . . . Since aggregator is an active transformation and it might have changed the order of the data, you need some mechanism to join back your data Expression is not an active transformation It retains all data Your aggregator might have "grouped by" duplicate data which resulted in reduction in number of rows