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
- 28940 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ani
We cannot use normalizer transformation in this case.
It used for normalizing the records.
Use decode in expression transformation and then aggregator
transformation.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / kalyan
Using Normalizer T/R we can achieve this; Horizantal
Pivoting i.e Coverting Single horizantal record into
Multiple vertical records. Even reverse logic i.e; Vertical
Pivoting also possible using the Normalizer T/R.
Please correct me if I am wrong !!
| Is This Answer Correct ? | 10 Yes | 17 No |
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
wt is Dynamic lookup Transformation? when we use?how we use?
where to select code page option?
What is the difference b/w natural key and surrogate key
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
Mention a few design and development best practices for informatica?
what is index?how it can work in informatica
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
What are the parts of Informatica Server?
what is the process of target load planing?
Teradata 
