Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - My source table having some records ,i want load 1st record and last record into one target?




438
views
asked marvit September 20, 2014 07:58 AM  

My source table having some records ,i want load 1st record and last record into one target?


           

1 Answers



 
answered By vishnoiprem   0  
You could have a shell script in the pre session command that would keep a backup of the original source file (assuming it may be required for future use) with a different name and then pick the head and tail record from the backup source file and populate the same in the original source file. Data from this source can then be loaded into the target.
This process would ensure that you dont have any performance issue which might have occured if you had brought the complete source data into the mapping and then filtered it out keeping the head and tail record.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert