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
- 29125 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
How would you join a node to the already existing domain?
Can u generate reports in Informatica?
Mention few advantages of router transformation over filter transformation.
How many transformations can be used in mapplets.
What is primary and backup node?
Is there any target staging area in informatica not staging area
pmscmd startworkflow -sv
What is aggregate cache in aggregator transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a mapplet/worklet in informatica?
What is the function of look up transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the different lookup cache(s)?
What is update strategy transform?
What is expression transformation?
