Answer Detail: RE: Sequential file with Duplicate Records

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

Question: Sequential file with Duplicate Records

Answer: A sequential file has 8 records with one column, below are the values in the column separated by space,
1 1 2 2 3 4 5 6

In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates.
File 1 records separated by space: 1 1 2 2
File 2 records separated by space: 3 4 5 6
How will you do it

August 08, 2009 05:43:33	#2
rameshkm	Member Since: April 2009 Total Comments: 7
RE: Sequential file with Duplicate Records
By using aggregator we can obtain this but the out put is like 1 2 and 3456

Back To Question