How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
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
What are ETL Tools?
What is meant by active and passive transformation?
permutations of mapplet
what is size of u r database?
Is it possible to revert a global repository to local one and why?
What is the meaning of decode in informatica?
How does a rank transform differ from aggregator transform functions max and min?
What do you mean by worklet?
what is mean by complex business rule ?
Can we create a Integration service without a Repository service and vice versa?
What are the transformations that are not supported in mapplet?
Differentiate between reusable transformation and mapplet.
How do you set a varible in incremental aggregation
What are the differences between a connected lookup and unconnected lookup?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?