Answer Posted / ashok1729

pushdown optimization will improve the performance of the
Load...

Let's see the E.g:

Sq ---> Flter_t ----> Target
[ sal<2000 ]

....

What are the different types of olap? Give an example?

999

---

What is decode in informatica?

1095

---

What is data caches/ index caches?

1044

---

What is meant by active and passive transformation?

1065

---

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

949

---

What are the tasks that can be performed using sq?

1045

---

What is xml source qualifier transformation in informatica?

1186

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1994

---

explain one complex mapping with logic? sales project?

6625

---

What do mean by local and global repository?

1176

---

What is depict expression change?

1060

---

What is primary and backup node?

1099

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1755

---

Enlist few areas or real-time situations where informatica is required.

1041

---

What is domain and gateway node?

1130

---