How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
- 3 Answers
- 27814 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
What is Data Caches size?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain your project of banking domian.
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is informatica metadata?
What is powercenter on grid?
Can anyone tell me the new features in Informatica 9 Version?
What is Cognos script editor?
What are the new features of informatica 9.x at the developer level?
Can you generate sequence numbers without using the sequence generator transformation?
Explain what is informatica metadata and where is it stored?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to do unit testing in informatica? How to load data in informatica ?
