How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
Answer Posted / ani
We cannot use normalizer transformation in this case.
It used for normalizing the records.
Use decode in expression transformation and then aggregator
transformation.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is data transformation manager process?
Explain in detail scd type 2 through mapping.
How to use procedural logic inside infromatica?
Where do we use mapping variables in informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Which transformation is needed while using the Cobol sources as source definitions?
What is xml source qualifier transformation in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can informatica load heterogeneous targets from heterogeneous sources?
What are some examples of informatica etl programs?
without table how to come first record only in oracle?
What is the sequence generator transformation in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How many ways are there to create ports?