Answer Posted / usha

by using dynamic lkp its possible...

in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...

when ever data inserted in to the target cache get
refreshed..

we ttake dynamic lkp..
by defaul..new lkp row port is added...

we should enable the associatve port...

here we should give the condition ..


in router we should give condition as newlkp=1--it will
insert...

if newlkp=0 means duplicate recorts

What is data transformation manager process?

1221

---

What is meant by incremental aggregation?

1183

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2310

---

What is joiner change?

1191

---

Repository user profiles

1811

---

Enlist the advantages of informatica.

1099

---

What is dynamic cache?

1085

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2168

---

Why do we need informatica?

1054

---

Explain the difference between a data warehouse and a data mart?

1111

---

Explain direct and indirect flat file loading (source file type) - informatica

1359

---

What all are steps in up gradation of Informatica server?

1093

---

Explain what is informatica metadata and where is it stored?

1108

---

What differs when we choose the sorted input for aggregator transformation?

1073

---

What does reusable transformation mean?

1192

---