1) I have a sequential file. It contain 16000 records.
2) I have a HASH file. It contains 2000 records
I desiged the job like,
Code: Select all
Seq_File _____> Transformer <--------- Hash File
|
|
|
v
Final_Seq_File
Seq_File contains Fund_Id, Portfolio_Id
Hash File contains Portfolio_id
Final_Seq_File contains 2000 records now.
But my requirement is, I have to store all 16000 records in the Final_Seq_File alongg with Portfolio_id (HASH FILE), if Portfolio_id is not matching with Seq_File, simply i have to store 'NULL'.