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



HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in ..

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

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in ..

Answer / friend

Use SQL Transformation for your process

Is This Answer Correct ?    0 Yes 1 No

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in ..

Answer / srinu

Hi,

Check with Normaliser Transformation
it will help you.


Any queries !! let me know
srinu.srinuvas@gmail.com

Is This Answer Correct ?    3 Yes 7 No

Post New Answer

More Informatica Interview Questions

What is update override?

1 Answers   Accenture,


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  


which transformation uses cache?

3 Answers   Keane India Ltd,






What are the basic needs to join two sources in a source qualifier?

4 Answers  


What are limitations of joiner transformation?

2 Answers   Exilant, TCS,


What is standalone command task?

0 Answers  


can every transfomation reusable?how?

2 Answers   Wipro,


What is source qualifier transformation?

1 Answers  


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.........?

4 Answers  


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?

0 Answers  


Categories