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.

What all are steps in up gradation of Informatica server?

1009

---

Why update strategy and union transformations are active? Explain with examples.

1192

---

Which development components of informatica have the highest usage?

1005

---

What is the difference between source qualifier transformations source filter to filter transformation?

1009

---

Explain the code page compatibility?

1032

---

How do you change a non-reusable transformation to reusable transformation?

962

---

Why do we need informatica?

943

---

Whats there in global repository

1653

---

How to do unit testing in informatica? How to load data in informatica ?

1061

---

Explain load alternative records / rows into multiple targets - informatica

1115

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1056

---

What is Index Caches size?

1075

---

What are the measure objects?

1138

---

Differentiate between a database and data warehouse?

1107

---