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
- 29255 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
my source is junk data how will u remove that junk data by using unix please any one replay me
how we can load rejected record's at run time?(not through bad files)
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is lookup change?
What is a shortcut and copy in Informatica and how two are different with each other?
What is the Rank index port in Rank transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the difference between a connected look up and unconnected lookup?
How to generate or load values in to the target table based on a column value using informatica etl tool.
where to store informatica rejected data? How to extract the informatica rejected data?
Clarify the aggregator change?
Separate from a database, an information bazaar, and an information stockroom?
lookup transformation with screenshots
Differentiate between joiner and lookup transformation?
