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
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 |
hw cn v elimate dublicate values from lookup without overriding sql?
what are objects in data warehouse?
What are the new features of informatica 9.x at the developer level?
what is shared Cache. when we will use shared Cache?
How to generate sequence numbers?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
Do joiner transformation use cache? If so describe?
how to load duplicate row in a target
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is incremantal aggregation?