How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
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
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Define Pmrep command?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the different types of olap? Give an example?
What is the fact table?
What do you mean incremental aggregation?
Explain the different dimensions.
draw informatica architecture 8.6 ?
What is resilience time?
Which files are created during the session rums by informatics server?
Can anyone tell me the new features in Informatica 9 Version?
What is the use of source qualifier?
What is deployment group?
What is the need of etl tools?
What are the different components of powercenter?