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 size of u r database?

2302

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7229

---

What are session parameters ? How do you set them?

1843

---

How many ways a relational source definition can be updated and what are they?

1013

---

What do you mean by filter transformation?

947

---

explan ur project architecture?

2061

---

What are the types of caches in lookup?

1048

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1624

---

What is union transformation in informatica?

1144

---

How do you set a varible in incremental aggregation

1886

---

How to implement security measures using repository manager?

1173

---

What is Cognos script editor?

4225

---

How to load a Dimension ? and how to load a fact table?

1409

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2719

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2267

---