We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, November 28, 2013

Tail Stage in DataStage


Tail Stage is another one stage from development stage category. It can have a single input link and a single output link.
The Tail Stage selects the last N records from each partition of an input data set and copies the selected records to an output data set.



a) Job Design :



b ) Tail Stage Properties :

Here we have selected the stage properties as below :

But, we can select 10 rows from any single or more partition, for that select "All Partition" as FALSE and select the partition ( 0,1 or more ) from which you need the tailed rows.

c) O/p file




No comments :

Post a Comment