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
- 9705 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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the different options available for update strategy?
Design time, run time. If you don't create parameter what will happen
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the types of caches in lookup?
How to load the data from people soft hrm to people soft erm using informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Enterprise data warehouse your projects phase by phase explain?
what are 3 tech challenges/ common issues you face?
Differentiate between joiner and lookup transformation?
How do you load only null records into target? Explain through mapping flow.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How many ways a relational source definition can be updated and what are they?
