How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
- 3 Answers
- 27813 Views
- I also Faced
- E-Mail Answers
Answer Posted / kt
We need to use NORMALIZER transformation to convert single
row into multiple rows.
Ex: NAME SALES QUARTERCID KT_NRMSALES_ID
Books 10 1 1
Books 20 2 2
Books 30 3 3
-----etc
TO --> NAME Q1 Q2 Q3
Movies 40 30 70
Books 10 20 30
Furniture 20 10 90
And we need to use aggregator tranformation to do reverse
operation.
In this we have to use any of the aggregate function
SUM/MIN/MAX and then decode to get the particualr quarter
and enable NAME port as group by.
sum(DECODE(QUARTERCID,1,SALES,NULL)) Q1
sum(DECODE(QUARTERCID,1,SALES,NULL)) Q2
sum(DECODE(QUARTERCID,1,SALES,NULL)) Q3
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What is the commit type if you have a transaction control transformation in the mapping?
How can repository reports be accessed without sql or other transformations?
What are the designer tools for creating transformations?
What does cheating measurement mean?
Whats there in global repository
How to Create a folder using pmrep command?
Explain about Informatica server process that how it works relates to mapping variables?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain what transformation and how many are there in informatica?
Explain in detail scd type 2 through mapping.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the main issues while working with flat files as source and as targets ?
What are mapplets? How is it different from a Reusable Transformation?
What is parallel processing in informatica?
