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?
Answers were Sorted based on User's Feedback
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 |
Answer / shaik mahamad rafi
first use concatenate operator '',then use union
Is This Answer Correct ? | 0 Yes | 2 No |
Why we use lookup transformations?
Describe an informatica powercenter?
star and snowflake schema?
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
Mention a few design and development best practices for informatica?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What are the different lookup cache(s)?
How can you display only hidden files in UNIX
In a table, 4 person having same salary. How to get Third person record only?
what is persistant cache in which situation we will use persistantcache
What do you understand by term role-playing dimension?