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
what is INFORMATICA TESTING process
Can u generate reports in Informatica?
Explain in detail scd type 2 through mapping.
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to go to the older version for a mapping?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain sessions?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
I have a flat file, want to reverse the contents of the flat file
Have you worked with/created Parameter file
Explain the tuning lookup transformation - informatica
What does refresh system mean, and what are its distinctive choice?
Implementation methodology