Answer Posted / rohit

I have below records.

EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-

101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship

What is the need of etl tools?

1078

---

What is informatica? Why do we need it?

1065

---

what is index?how it can work in informatica

2003

---

How many numbers of sessions can one group in batches?

1041

---

If informatica has its scheduler why using third party scheduler?

1224

---

How to use procedural logic inside infromatica?

1163

---

What are different types of transformations available in informatica?

955

---

What is joiner transformation in informatica?

1011

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1630

---

what is diff b/t sorter t/r and agg have the option sorter property...

2147

---

 Informatica Checkpoints

3284

---

Make a note of the quantity vaults made in informatica?

959

---

What is a pre-defined event and user-defined event?

996

---

What are the designer tools for creating transformations?

1071

---

How to go to the older version for a mapping?

1048

---