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 are the reusable transformations?
What is persistent lookup cache?
How can we remove the duplicates from flat file source?
What is the use of transformation?
Where do we use mapping variables in informatica?
Design a mapping to load a target table with the following values from the above source?
Enlist the differences between database and data warehouse.
What is different between the data warehouse and data mart?
can anyone explain me about retail domain project in informatica?
How do you change a non-reusable transformation to reusable transformation?
how we can load rejected record's at run time?(not through bad files)
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the types of data warehouses?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the types of caches in lookup? Explain them.