My source data like...
Empid Name
10 chandra
10 sekhar
I am expecting result is
Empid Ename
10 Chandrasekhar
How can we solve this prob?
Answer Posted / santosh
Follow the below step.
1.Take the sorter transformation and sort by empid(IF some cases empid not in sequence).
2.Take a expression transformation with below condition.
a. CURRENT_ID=EMPID
b. EMPID=EMPID
C. name=name
d. NAME_VAR= IIF(CURRENT_ID = NEXT_ID,(NAME_VAR ||name ),name)
e.NAME_OUT= NAME_VAR
f. NEXT_ID= CURRENT_ID
3.Take a aggregator transformation and give group by port as empid.
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
What is domain and gateway node?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Could you explain what is enterprise data warehouse?
What is an active transformation?
What is dynamic cache?
What is the Process to creating lookup transformation in informatica
what is the difference between informatica6.1 and infomatica7.1
Can we get 1st record through Informatica(without sequence number).
Have you worked with/created Parameter file
Why union transformation is an active transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How many dimensions are there in informatica?
What is the function of aggregator transformation?
Reusable transformation and shortcut differences