Answer Posted / sanjay

well if u hav all related sources then u can probably go
for joiner but make sure that use less no. of joiner as it
may decrease your performance.
if u hav sources with same structure and data types then u
can probably go for set operation and matchin it with your
target.
the third one is u hav to do a lot of transformation based
on some analysis and might be u can create differnet
aliases for your target and you can apply your
transformation.


plz let me know if any clarification . your comment will be
appreciatable. :)

Differentiate between source qualifier and filter transformation?

1584

---

What are the different lookup cache(s)?

1119

---

What do you understand by SOA of Informatica?

992

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

---

 Informatica Checkpoints

3334

---

Enlist the various types of transformations.

1060

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1052

---

What are the features of complex mapping?

1161

---

What is the way to execute pl/sql script using informatica mapping?

1613

---

What does role playing dimension mean?

1048

---

Target increases every day even though no new record was inserted

1584

---

How we can create indexes after completing the load process?

1161

---

What are the new features of Power Center 5.0?

1780

---

What is target designer and target load order?

1110

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---