How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
Answer Posted / kalyan
Using Normalizer T/R we can achieve this; Horizantal
Pivoting i.e Coverting Single horizantal record into
Multiple vertical records. Even reverse logic i.e; Vertical
Pivoting also possible using the Normalizer T/R.
Please correct me if I am wrong !!
| Is This Answer Correct ? | 10 Yes | 17 No |
Post New Answer View All Answers
What is a stored procedure transformation?
How to generate sequence numbers without using the sequence generator transformation?
How would you join a node to the already existing domain?
Is it possible to revert a global repository to local one and why?
Explain sessions and how many types of sessions are there?
Explain the difference between a data warehouse and a data mart?
How an expression transformation differs from aggregator transformation?
permutations of mapplet
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are mapplets?
what is the size of u r source(like file or table)?
How you can differentiate between connected lookup and unconnected lookup?
What is parallel processing in informatica?
How we can use union transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.