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

Informatica - How will you update the first four rows and insert next four rows in a mapping?




512
views
asked marvit September 20, 2014 07:59 AM  

How will you update the first four rows and insert next four rows in a mapping?


           

1 Answers



 
answered By vishnoiprem   0  
Source qualifier trf take a exp trf with a sequence gen and from there give it to filer trf. write there a condition next value<=4 and give it to update stategy trk. and there give condition as dd_insert and then to targer,this all comes
in first pipeline.
In second pipeline drag the ports from exp trf and again take a filter trf,over there give condition as next_val>4 and next_val<9. give this to update trf and then to target.
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