Thursday, 3 September 2015

DataStage Scenario #3 - Fetch middle one



Develop a DataStage Job to achieve below requirement -




Input:
Single_Column
Atul Kr Singh
Geeta Vishwas
Anoop Despande
Rohit S Pande
Ankit Singh
Garima Bhatia Arya


Output:
Fname   Mname   Lname
Atul       Kr         Singh
Geeta                  Vishwas
Anoop                 Despande
Rohit     S           Pande
Ankit                  Singh
Garima   Bhatia   Arya


For more Scenario -  CLICK HERE