Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / chandumba2005

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 is meant by direct and indirect loading options in sessions?

4 Answers  

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

What do you understand by a term domain?

0 Answers  

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

What is a joiner transformation and why it is an active one?

0 Answers  

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

How would you copy the content of one repository to another repository?

0 Answers  

.prm wirh repalce .txt is possible?

2 Answers  

What all join we can perform in LOOKUP transformation?

0 Answers  

why we use stored procedure transformation?

4 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories