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
State the differences between sql override and lookup override?
How we can create indexes after completing the loan process?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is informatica? Why do we need it?
can u give example for factless fact table
Mention few power centre client applications with their basic purpose?
How to use pmcmd utility command?
Can we override a native sql query within informatica?
How to generate sequence numbers?
What are connected or unconnected transformations?
Explain why we use partitioning the session in informatica?
What are multi-group transformations?
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 ?
What is joiner transformation in informatica?
What is update strategy transform?