Answer Posted / ashok1729

pushdown optimization will improve the performance of the
Load...

Let's see the E.g:

Sq ---> Flter_t ----> Target
[ sal<2000 ]

....

Why do we need informatica?

925

---

How can one identify whether mapping is correct or not without connecting session?

1367

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2292

---

How would you join a node to the already existing domain?

1065

---

What is the function of union transformation?

1062

---

How can a transformation be made reusable?

1076

---

What is Cognos script editor?

4158

---

What are multi-group transformations?

1010

---

How to create or import flat file definition in to the warehouse designer?

1018

---

What are the differences between source qualifier and joiner transformation?

992

---

How do you change a non-reusable transformation to reusable transformation?

941

---

Why filter transformation is an active one?

928

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1106

---

Differentiate between router and filter transformation?

951

---

How can we use mapping variables in informatica?

1001

---