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

Answer Posted / gvmahesh

By using Sequencegenerator T/R we can normalize the
denormalized tables.

Because, By using SEQ T/R we can generate surrogatekey
column.then we can define that as Primarykey column.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the differences between sql override and lookup override?

892


How we can create indexes after completing the loan process?

991


Explain where to store informatica rejected data? How to extract the informatica rejected data?

841


What is informatica? Why do we need it?

883


can u give example for factless fact table

5996


Mention few power centre client applications with their basic purpose?

750


How to use pmcmd utility command?

812


Can we override a native sql query within informatica?

845


How to generate sequence numbers?

847


What are connected or unconnected transformations?

888


Explain why we use partitioning the session in informatica?

828


What are multi-group transformations?

824


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6673


What is joiner transformation in informatica?

864


What is update strategy transform?

838