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
- 28908 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 |
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
what is the look up transformation?
What are the circumstances that infromatica server results an unreciverable session?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
How to improve the performance of Aggregate transformation?
what is unique constraint error ?
How can you recover the session in sequential batches?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
In warehouses how many schemas are there?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
What are the types of schemas we have in data warehouse and what are the difference between them?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Teradata 
