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



My source data like... Empid Name 10 chandra 10 sekhar I am ex..

Answer / 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

My source data like... Empid Name 10 chandra 10 sekhar I am ex..

Answer / satya

USE WM_CONCAT() FUNCTION

Is This Answer Correct ?    0 Yes 0 No

My source data like... Empid Name 10 chandra 10 sekhar I am ex..

Answer / shaik mahamad rafi

first use concatenate operator '',then use union

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

Why we use lookup transformations?

1 Answers  


Describe an informatica powercenter?

0 Answers  


star and snowflake schema?

6 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

0 Answers   SeeInfoBiz, TCS,


Mention a few design and development best practices for informatica?

0 Answers  






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

4 Answers   Polaris,


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

4 Answers   Magna Infotech,


What are the different lookup cache(s)?

0 Answers  


How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,


In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


What do you understand by term role-playing dimension?

0 Answers  


Categories