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.....
Answers were Sorted based on User's Feedback
Answer / harish kakarlapudi
Hi Srinivas,
It is opp. to Normalisation process, so, i think that it
cannot be done using Normaliser transformation. Can you
give me any idea , pls...
Is This Answer Correct ? | 0 Yes | 0 No |
What is update override?
Performance wise which is better joiner or look up ? Give me with example?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
who is the best faculty for informatica in hyderabad ameerpet?
which transformation uses cache?
What are the basic needs to join two sources in a source qualifier?
What are limitations of joiner transformation?
What is standalone command task?
can every transfomation reusable?how?
What is source qualifier transformation?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
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?