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

Informatica - In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?




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

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?


           

1 Answers



 
answered By vishnoiprem   0  
By using Sequence generator transformer  we can normalize the denormalized tables.
Because, By using SEQ transformer  we can generate surrogate key column then we can define that as Primary key column for the target table
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