how to convert
101 raja 101 raja sekar reddy
101 sekar---------->
101 reddy
Answer Posted / purushotham perumalla
Create variable ports in Expression transformation to
concat name if the number is same as follows
Assume the input field names are number and name
define the variable ports in expression transformation in
the following order
v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name
The output of o_name will be as follows
number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy
Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is the -ve test case in your project.
Where do we use mapping variables in informatica?
Explain lookup transformation is active in informatica
How would you join a node to the already existing domain?
What is the difference between router and filter?
What are the restrictions of union transformation?
In which transformation you cannot drag ports into it?
Explain scd type 3 through mapping.
What is the need of etl tools?
Explain sessions and how many types of sessions are there?
How to generate sequence numbers without using the sequence generator transformation?
Mention few power centre client applications with their basic purpose?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to generate sequence numbers?