Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10709 Views
- TCS, I also Faced
- E-Mail Answers
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 Data Caches size?
What is the Process to creating lookup transformation in informatica
Explain the different dimensions.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is complex mapping?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is rank transformation in informatica
How to delete duplicate row using informatica?
What is the scenario which compels informatica server to reject files?
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?
What is primary and backup node?
Define enterprise data warehousing?
What are the types of schemas we have in data warehouse.
What is an expression transformation?
How to load a Dimension ? and how to load a fact table?
