Answer Posted / sehaj

BY USING DYNAMIC LOOK UP CACHE!

Explain what are the different types of transformation available in informatica.

1066

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1740

---

What is joiner change?

1092

---

Define the various join types of joiner transformation?

959

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2324

---

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?

1457

---

how to create user defined function (udf) in informatica

1268

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1043

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1056

---

What are the different ways to implement parallel processing in informatica?

1359

---

Define filter transformation?

1040

---

How to go to the older version for a mapping?

1044

---

What are the new features of informatica 9.x developer?

920

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5708

---

How to extract the informatica rejected data?

1176

---