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
- 29090 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
Implementation methodology
Explain pushdown optimization and types in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How do you promote a non-reusable transformation to reusable transformation?
Separate from an archive server and a powerhouse?
What do you understand by SOA of Informatica?
How do you load alternate records into different tables through mapping flow?
How can you define user defied event?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the components of Informatica? And what is the purpose of each?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Write the advantages of partitioning a session?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is exclusive and normal mode for repository services?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
