Answer Posted / kalyan

In SQL override (Source Qualifier level) write a query to
join the 2 tables like emp & dept as follows:

Select * from emp,dept;

The above query will return the cartesian product of the 2
tables; BTW, this don't have any condition...

What do you mean by blocking transformation?

972

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

---

How do you load unique records into one target table and duplicate records into a different target table?

1166

---

What is data caches/ index caches?

1024

---

How to differentiate between the active and passive transformations?

1078

---

What the difference is between a database, a data warehouse and a data mart?

1083

---

What if the source is a flat-file?

1046

---

Can informatica load heterogeneous targets from heterogeneous sources?

1122

---

How to load the data from people soft hrm to people soft erm using informatica?

953

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1038

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2281

---

How to join three sources using joiner? Explain though mapping flow.

1092

---

Scheduling properties,whats the default (sequential)

1896

---

How can we use batches?

968

---

Explain the features of connected and unconnected lookup.

877

---