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
- 7792 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / swapnil
no need to use normalizer here, take 3 expression and 3
instance of target.
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.
Make 3 instances of the target. Connect port from exp_1 to
target_1. Connect port from exp_2 to target_2 and connect
port from exp_3 to target_3.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are some examples of informatica etl programs?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain dynamic target flat file name generation in informatica
design of staging area?
As union transformation gives UNION ALL output, how you will get the UNION output?
Different circumstance which drives informatica server to expel records?
Enlist the tasks for which source qualifier transformation is used.
Define filter transformation?
How can we store previous session logs?
What is the difference between source qualifier transformations source filter to filter transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
Differentiate between a repository server and a powerhouse?
What is the sequence generator transformation in informatica?
What if the source is a flat-file?
Write the different tools in the workflow manager?
