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
- 10567 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / friend
Use SQL Transformation for your process
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
where to store informatica rejected data? How to extract the informatica rejected data?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Enlist the differences between database and data warehouse.
What is sq transformation?
How to do unit testing in informatica?
Can u generate reports in Informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Explain the different lookup methods used in informatica?
How can you define user defied event?
Is there any target staging area in informatica not staging area
Explain why we use partitioning the session in informatica?
Describe data concatenation?
What are the tuning techniques you applied during your last project
Explain the use of aggregator cache file?
