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 meant by a domain?

0 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

---

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---

permutations of mapplet

0 Answers   TCS,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---