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
Explain how to import oracle sequence into informatica?
What is the need of etl tools?
What are the issues you have faced in your project? How did you overcome those issues?
What is deployment group?
What is InformaticaPowerCenter?
What are the informatica performance improvement tips
What is the need for an etl tool?
What is the surrogate key?
define galaxy repository in informatica
Define filter transformation?
What is meant by lookup transformation?
Performance tuning( what you did in performance tuning)
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
complex mapping ur project u r invlve can u explain and give real time example give me ?
what is degenerated dimension?