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

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

Define Update Override?

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  

---

Tell me about MD5 functions in informatica

0 Answers  

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

What is workflow manager?

0 Answers  

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

---