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

Informatica - Why cant we put a sequence generator or upd strategy transformation before joiner transformation?




996
views
asked marvit September 20, 2014 08:02 AM  

Why cant we put a sequence generator or upd strategy transformation before joiner transformation?


           

1 Answers



 
answered By vishnoiprem   0  
Sequence Generator will always used to generate seq numbers. Here output  of seq generator will be unique value(NEXT VAL) and also a new value  which can't be joined in joiner transformation, so if you observe closely  on joiner, it always joins the data from different source not from  recently generated data. This makes the main cause of seq generator and joiner is  different.
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