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 filelist concept in informatica

4 Answers  

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

without table how to come first record only in oracle?

0 Answers  

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

can anyone suggest best free Talend data integration training online

0 Answers  

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

What are the components of the workflow manager?

0 Answers  

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---