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

Monday, January 27, 2014

DataStage Scenario - Problem12



Goal : Add a comment line with each row of input file


Input1 :

Name, Dept, Salary
CHRISTINE,A00,152750.00
MICHAEL,B01,94250.00
SALLY,C01,98250.00
JOHN,E01,80175.00
IRVING,D11,72250.00
EVA,D21,96170.00
EILEEN,E11,89750.00
THEODORE,E21,86150.00



Input2 :

Comment
This is a list of employees of Sample DB.


Output file :


Name, Dept, Salary,Comment
CHRISTINE,A00,152750.00,This is a list of employees of Sample DB.
MICHAEL,B01,94250.00,This is a list of employees of Sample DB.
SALLY,C01,98250.00,This is a list of employees of Sample DB.
JOHN,E01,80175.00,This is a list of employees of Sample DB.
IRVING,D11,72250.00,This is a list of employees of Sample DB.
EVA,D21,96170.00,This is a list of employees of Sample DB.
EILEEN,E11,89750.00,This is a list of employees of Sample DB.
THEODORE,E21,86150.00,This is a list of employees of Sample DB.


No comments :

Post a Comment