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
- 28903 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
tell me 5 session failure in real time how can you solve that in your project?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is workflow monitor?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
waht type of interface is used for testing the data in informatica
Enterprise data warehouse your projects phase by phase explain?
What does reusable transformation mean?
what is degenerated dimension?
what is the size of u r source(like file or table)?
What are the different versions of informatica?
Performance tuning( what you did in performance tuning)
What are active and passive transformations?
What is lookup transformation?
In informatica workflow manager, how many repositories can be created?
Target increases every day even though no new record was inserted
