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
- 28937 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 to extract sap data using informatica? What is abap? What are idocs?
How many input parameters can exist in an unconnected lookup?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can one identify whether mapping is correct or not without connecting session?
What are Dimensional table?
What is rank transformation?
What are junk dimensions?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the tuning lookup transformation - informatica
Where do we use mapping variables in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you load unique records into one target table and duplicate records into a different target table?
Enlist few areas or real-time situations where informatica is required.
How can we delete duplicate rows from flat files?
Have you worked with/created Parameter file
