Interested to Buy Any Domain ? << Click Here >> for more details...
The Source coloumns are A,B,C with data row1- 10,20,30 row2-
40,50,60 row3-70,80,90 and so on. In the target I want one
coloumn with the following data, Coloumn-X, row1-10,row2-
20,row3-30,row4-40,row5-50 and so on. How to achieve this?
- 3 Answers
- 7797 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh rathore
Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
and we merge all output of all 3 expressions by UNION trans
and direct load to tgt from union
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we create index after completion of load process?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How are the sources and targets definitions imported in informatica designer?
How do you load only null records into target?
What is a rank transform?
whats the logic to load the lower level of granularity of data to fact table.
What is a shortcut and copy in Informatica and how two are different with each other?
What is data caches/ index caches?
Explain the different lookup methods used in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What does update strategy mean, and what are the different option of it?
What is data movement mode in Informatica and difference between them?
What could be the possible resons of locks by user?
How many ways a relational source definition can be updated and what are they?
what is the Default Source Option For Update Strategy Transformation?
