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


Please Help Members By Posting Answers For Below Questions

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

771


What are the different options available for update strategy?

787


Mention a few design and development best practices for informatica?

767


Could you explain what is enterprise data warehouse?

784


What are the various types of transformation?

911


How to update a particular record in target with out running whole workflow?

1376


Explain the mapping variable usage example in informatica

876


design of staging area?

1829


Briefly describe lookup transformation?

814


How to extract sap data using informatica?

816


Explain the etl program with few examples.

785


What do you understand by a term domain?

889


How can you define user defied event?

843


Explain dynamic target flat file name generation in informatica

863


How do you load only null records into target?

975