HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard.....
Answer Posted / friend
Use SQL Transformation for your process
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is different between the data warehouse and data mart?
Explain load alternative records / rows into multiple targets - informatica
What is aggregator transformation in informatica?
What is meant by incremental aggregation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the features of complex mapping?
What are the mapping parameters and mapping variables?
What is the need for an etl tool?
what are the deliverables?in your project?
How do you load alternate records into different tables through mapping flow?
How do you take back up of repository?
Enterprise data warehouse your projects phase by phase explain?
What is standalone command task?
How to configure mapping in informatica?