How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
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 |
What is the query to find nth highest salary? What is the use of cursors?
What is decode in informatica?
How to load the source table into flat file target(with columns) in informatica?
Two different admin users created for repository are ______ and_______
What is a joiner transformation?
What are the ETL tools available in DWH?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
what are the types of facts with Examples?
What is status code in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
How to load duplicate records in to a target table which has a primary key?