-
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?
-
-
How to load data based on even and odd record numbers
In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and winch transformations we are using?and explain logic?
-
How to create a TIME DIMENSION in the Target Database(Oracle)?
There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?