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 the use of transformation?
What is the use of an aggregator cache file?
What is an unconnected transformation?
What are ETL Tools?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is powercenter on grid?
Clarify the utilization of aggregator cache record?
How to load the data from people soft hrm to people soft erm using informatica?
What is status code in informatica?
What are batches?
Under which circumstances, informatica server creates reject files?
can you please explain me pre session and post session options?
On which transformations you created partitions in your project?
What you know about transaction control transformation?