merge Column level

[New2DS]

Two input flat files with two columns each

Code: Select all

File 1:
Rec_Cnt  Total_Amount
125      5000.00

File 2:
Rec_cnt  Total_Amount
275	 15000.00

OutputFile: Record count from the second file and total amount from the first file.
Rec_cnt  Total_Amount
275	 5000.00

There are no keys in the two files. The way I tried is to add a dummy key to both files and coping one of the file to a hash and doing a lookup on the dummy key and taking the required columns on the output. It worked but like to know is there any efficient way of doing this?

thanks

[Sainath.Srinivasan]

Perform a 'paste' command in Unix.

[talk2shaanc]

Through datastage, i dont think there is anything better than the logic you are already using.