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
What is the reusable transformation?
which one is better performance wise joiner or look up
What is the use of source qualifier?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
tell me about your project functionality
What all are steps in up gradation of Informatica server?
Enlist the tasks for which source qualifier transformation is used.
What are the differences between oltp and olap?
What are the modules in Power Center
differences between service based and product based?
What are the advantages of using informatica as an etl tool over teradata?
What is informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the popular informatica products?
permutations of mapplet