Answer Posted / 24/12/2007

if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache

What are the types of caches in lookup? Explain them.

917

---

What all are steps in up gradation of Informatica server?

988

---

To import the flat file definition into the designer where should the flat file be placed?

1004

---

Explain lookup transformation in informatica

1004

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

991

---

Explain about cumulative Sum or moving sum?

976

---

Explain the different lookup methods used in informatica?

972

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1442

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1110

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1986

---

When do you use sql override in a lookup transformation?

1024

---

What is meant by a domain?

1078

---

How do you update the records with or without using update strategy?

1055

---

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

930

---

What do you understand by SOA of Informatica?

925

---