Answer Posted / devendar pd

if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.

I think we can't remove duplicates only by using filter

What are the main issues while working with flat files as source and as targets ?

1111

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1035

---

Mention some types of transformation?

1003

---

Which transformation is needed while using the Cobol sources as source definitions?

1132

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1089

---

Describe data concatenation?

1021

---

If informatica has its scheduler why using third party scheduler?

1205

---

Name the different lookup cache(s)?

1168

---

what is the size of u r source(like file or table)?

2207

---

How does a sorter cache works?

1014

---

tell me 5 session failure in real time how can you solve that in your project?

2204

---

What is difference between a gateway node and worker node?

1082

---

What are the types of presistent cache in look up tr.

2016

---

What is lookup change?

998

---

What are active and passive transformations?

1033

---