suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
Answer Posted / sankar
AS PER Reddevilzzzz ANS ALMOST OK
BUT NO NEED TO SELECT GROUP BY IN AGGREGATOR T/R BCOZ IF U
SELECT GROUP BY THERE IS NO DUPLICATE SO WITH OUT
DUPLICATES HOW WE PASS THE DUPLICATES IN T2.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
What is xml source qualifier transformation in informatica?
According to his methodology what all you need before you build a datawarehouse
hi real timers . iam waiting for ur reply regarding ETL TESTING
update strategy transformation in informatica
What the difference is between a database, a data warehouse and a data mart?
What are the types of caches in lookup?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is the size of your data warehousing?
What do you understand by term role-playing dimension?
Why sorter is an active transformation?
Define enterprise data warehousing?
server hot-ws270 is connect to Repository B. What does it mean?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the databases that informatica can connect to windows?