Interested to Buy Any Domain ? << Click Here >> for more details...
How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
- 3 Answers
- 29091 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
What is a rank transform?
What is option by which we can run all the sessions in a batch simultaneously?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Write the unconnected lookup syntax and how to return more than one column.
What is the sql query overwrite in source qualifier in informatica
Describe an informatica powercenter?
What is the Rank index port in Rank transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Slowly changing dimensions, types and where will you use them
Implementation methodology
How we can create indexes after completing the loan process?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can we use mapping variables in informatica? Where do we use them?
What is a surrogate key?
