Monday, May 9, 2011
Aggregator Stage and Filter Stage with example
And we need to get the same multiple times records into the one target.
And single records not repeated with respected to dno need to come to one target.
Take Job design as
Read and load the data in sequential file.
In Aggregator stage select group =dno
Aggregator type = count rows
Count output column =dno_cpunt( user defined )
In output Drag and Drop the columns required.Than click ok
In Filter Stage
----- At first where clause dno_count>1
-----Output link =0
-----At second where clause dno_count<=1 -----output link=0 Drag and drop the outputs to the two targets. Give Target file names and Compile and Run the JOb. You will get the required data to the Targets.
If you know Better Answer for Above Question Comment below to Answer.
Change Capture Stage is used to capture the changes between two sources based on the change code. Change Code is the Code generated w...
Some times we get the data as below Customers 1,tommy,2000 2,sam,2300 3,margaret,2000 4,pinky,1900 5,sheela,2000 Take Job Design...