-
find out duplicate records using aggregator
How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the columns. if the count=1 then it will be a valid record. what to do if the count >2.means file contains duplicate records.Why we need to use joiner after aggregator?
-
Informatica : set statement in update
Need to update the existing records,The record which is coming for update should be inserted and also the previous record's one column must be modified. i have used look up to look up the data.used router to separate the data for insertion and update.Used expression to calculate something on those new records for update.service_code valid_startdate valid_enddate01 2003-03-03...
-
-