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

Informatica - Why do we go for update strategy tr in SCD rather using the session properties?




564
views
asked marvit September 20, 2014 08:03 AM  

Why do we go for update strategy tr in SCD rather using the session properties?


           

1 Answers



 
answered By vishnoiprem   0  
Actually its important to use a update strategy transformation in the SCD's as SCDs maintain some historical data specially type 2 dimensions. In this case we may need to flag rows from the same target for different database operations. Hence we have no choice but to use update strategy as at session level this will not be possible.
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