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

Mention few advantages of router transformation over filter transformation.

835


Explain the different dimensions.

739


tell me about your project functionality

2097


Explain direct and indirect flat file loading (source file type) - informatica

1079


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

824


What are the static cache and dynamic cache in informatica?

968


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

805


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2190


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

986


COM components can be used in Informatica

2095


What is transformation?

881


What do you understand by a term domain?

876


How do you convert single row from source into three rows into target?

876


Plz can any one say me how to get the informatica certification materials and dumps

1810


What do you understand by term role-playing dimension?

784