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
- 7918 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
What is expression transformation?
What is Cognos script editor?
what is the complex transformation you used in informatica
What is a mapplet/worklet in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to load the data from people soft hrm to people soft erm using informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How is union transformation utilized?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How we can create indexes after completing the loan process?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Differentiate between Load Manager and DTM?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
