Answer Posted / 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.

Different qualification between a related rotate toward the sky and isolates look upward?

929

---

How to update or delete the rows in a target, which do not have key fields?

1116

---

What is sq transformation?

1079

---

Explain lookup transformation source types in informatica

1040

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1012

---

What is the difference between a repository server and a powerhouse?

1412

---

What is main use of mapplet?

1070

---

Explain dynamic target flat file name generation in informatica

1007

---

whats the logic to load the lower level of granularity of data to fact table.

2206

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2075

---

Explain the types of transformations?

1005

---

Enlist the various types of transformations.

952

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076

---

What is powercenter on grid?

1125

---

How can informatica be used for an organization?

1130

---