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
- 7641 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 flashback table ? Advance thanks
How to load data in informatica ?
Briefly define a session task?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Do you find any difficulty while working with flat files as source and target?
Different sorts of metadata that stores in the storage facility?
Explain what are the different versions of informatica?
What is substr in informatica?
How do you use reject loader.
How can you generate reports in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Which transformation is needed while using the Cobol sources as source definitions?
What are the reusable transformations?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
