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

Informatica - In SCD type what is the alternative to that lookup transformation?




784
views
asked marvit September 20, 2014 08:04 AM  

In SCD type what is the alternative to that lookup transformation?


           

1 Answers



 
answered By vishnoiprem   0  
"update else insert" in the properties of session.

You can use Joiner transformation to design scd Type1 manually. Import target as source and use joiner
transformation. Use expression to insert and update the rows into 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