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
- 7804 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 is the difference between informatics 7x and 8x and what is latest version?
What is the function of union transformation?
What is exclusive and normal mode for repository services?
how we can load rejected record's at run time?(not through bad files)
Differentiate between Load Manager and DTM?
What is source qualifier transformation in informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is data movement mode in Informatica and difference between them?
Explain the different kinds of facts.
What are the restrictions of union transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is meant by pre and post session shell command?
What is a sequence generator transformation?
What are connected or unconnected transformations?
What is option by which we can run all the sessions in a batch simultaneously?
