Tuesday, 29 September 2015

DataStage Scenario #6 - Populate 'Not Found'



Scenario:
       Design a job which read a flat file and populate the output as NOT FOUND which is not available in the other file.

Example Input:

Input1 Input2
Atul Amruta
Neeraj Atul
Anita Divya
Amruta Santosh
Divya Pramod
Swapnil
Pramod
Vivek
Ashish
Amit
Santosh



Output:

Output
Neeraj
Anita
Swapnil
Vivek
Ashish
Amit



Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx