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 / 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 View All Answers
What is an Integration service in Informatica?
What is InformaticaPowerCenter?
what is index?how it can work in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can we use mapping variables in informatica? Where do we use them?
What is main use of mapplet?
How can you differentiate between powercenter and power map?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Which means the first record should come as last record and last record should come as first record and load into the target file?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is xml source qualifier transformation in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How can you generate reports in informatica?
What is dimensional table?
How do you update the records with or without using update strategy?