Answer Posted / ashok1729

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

Let's see the E.g:

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

....

What all are steps in up gradation of Informatica server?

614

---

What is union transformation?

565

---

Differences between connected and unconnected lookup?

600

---

What is dimensional table? Explain the different dimensions.

645

---

what is Active lock explain

2361

---

---

What is xml source qualifier transformation in informatica?

708

---

What are the main issues while working with flat files as source and as targets ?

643

---

Define Pmrep command?

628

---

Can we create a Integration service without a Repository service and vice versa?

719

---

What is the sequence generator transformation in informatica?

608

---

What is informatica etl tool?

544

---

Tell me about Propagate functions in informatica

518

---

What does update strategy mean, and what are the different option of it?

581

---

How we can create indexes after completing the loan process?

721

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

588

---