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.....
- 3 Answers
- 9193 Views
- TCS, I also Faced
- E-Mail Answers
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 |
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
How do you create single lookup transformation using multiple tables?
How to send duplicates to one target and unique rows to one target?target is empty
Difference Between ETL & ELT?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the reusable transforamtions?
Are there any types of Dynamic Caches in informatica
How the dimensions will be loaded?
What are the methods for creating reusable transforamtions?
How you count the number of records available at your source?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is difference between a connected look up and unconnected look up?
Teradata 
