Answer Posted / pradeep

Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.

What is the format of informatica objects in a repository?

972

---

What are the types of data warehouses?

1424

---

Under which circumstances, informatica server creates reject files?

1023

---

how many types of dimensions are available in informatica?

994

---

How to update a particular record in target with out running whole workflow?

1529

---

What is data movement mode in Informatica and difference between them?

1056

---

What is InformaticaPowerCenter?

1068

---

Define the various join types of joiner transformation?

940

---

What is the scenario which compels informatica server to reject files?

1006

---

Informatica settings are available in which file?

935

---

How to implement security measures using repository manager?

1078

---

is it possible to index the data in cache of lkp transformation ?

1956

---

How to update source definition?

1030

---

How to extract the informatica rejected data?

1158

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1982

---