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.

Answer / satya

USE WM_CONCAT() FUNCTION

Answer / shaik mahamad rafi

first use concatenate operator '',then use union

What is power center repository?

1 Answers  

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

expain about the tune parameters?

0 Answers   TCS,

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---

What is the benefit of partitioning a session?

0 Answers  

---

What is a transaction control transformation?

0 Answers   Informatica,

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---