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

What is the reusable transformation?

839


which one is better performance wise joiner or look up

853


What is the use of source qualifier?

887


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6898


tell me about your project functionality

2099


What all are steps in up gradation of Informatica server?

817


Enlist the tasks for which source qualifier transformation is used.

787


What are the differences between oltp and olap?

740


What are the modules in Power Center

1436


differences between service based and product based?

1792


What are the advantages of using informatica as an etl tool over teradata?

787


What is informatica?

880


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2111


What are the popular informatica products?

811


permutations of mapplet

2261