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
Mention few power centre client applications with their basic purpose?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain the types of transformations?
How to elaborate tracing level?
Explain the difference between mapping parameter and mapping variable?
What are the types of schemas we have in data warehouse.
What are the prerequisite tasks to achieve the session partition?
How we can create indexes after completing the loan process?
How do you load only null records into target?
What is sequence generator transformation in informatica?
Differentiate between joiner and lookup transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Informatica settings are available in which file?
Sequence generator, when you move from develoment to production how will you reset
What is rank transformation?