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?
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 the tasks that source qualifier perform?
What do mean by local and global repository?
Explain the aggregator transformation?
Define pmcmd command?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Is it possible to revert a global repository to local one and why?
What is the command used to run a batch?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are data-driven sessions?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
in reporting we add some new objects,how we get the count of the newly added objects to the report
update strategy transformation in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
What is complex mapping?
How many number of sessions can one group in batches?