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

Explain in detail about scd type 1 through mapping.

1524

---

Explain the shared cache and re-cache?

1106

---

During the running session, output files are created by informatica server. Enlist few of them.

975

---

What is the commit type if you have a transaction control transformation in the mapping?

1028

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2192

---

Quickly characterize reusable change?

1113

---

Explain sql transformation in script mode examples in informatica

1122

---

Define update strategy?

1210

---

Differentiate between joiner and lookup transformation?

1100

---

What is the reusable transformation?

1043

---

What is a joiner transformation?

984

---

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

1052

---

can anyone explain me about retail domain project in informatica?

7941

---

Explain the use of aggregator cache file?

1245

---

How to create Target definition for flat files?

1211

---