How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
- 3 Answers
- 27815 Views
- I also Faced
- E-Mail Answers
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
How to handle decimal places while importing a flatfile into informatica?
What is an Integration service in Informatica?
What is the function of aggregator transformation?
Differentiate between a repository server and a powerhouse?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Differences between version 7.x and 8.x.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is a connected transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can we delete duplicate rows from flat files?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How can you differentiate between powercenter and power map?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the different lookup cache(s)?
How to update source definition?
