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
Explain scd type 3 through mapping.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can informatica be used for an organization?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
On which transformations you created partitions in your project?
What are the new features of informatica 9.x at the developer level?
What is the surrogate key?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Clarify the aggregator change?
Difference between Target-based loading and constraint-based loading?
Mention few advantages of router transformation over filter transformation.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What do you mean incremental aggregation?
How we can use union transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica