Answer Posted / rao

What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?

If not declared in Parameter file, power center server will
try to fetch the value from initial value. If not then from
the default value.

Explain the mapping variable usage example in informatica

725

---

What is meant by pre and post session shell command?

737

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2502

---

What you know about transaction control transformation?

645

---

Explain joiner transformation in informatica

770

---

---

Separate from a database, an information bazaar, and an information stockroom?

701

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

708

---

What is a transaction control transformation?

854

---

Define mapplet?

706

---

What is target load order?

898

---

What is a joiner transformation and why it is an active one?

653

---

What is xml source qualifier transformation in informatica?

825

---

What are the restrictions of union transformation?

672

---

Explain the tuning lookup transformation - informatica

692

---

Explain the etl program with few examples.

638

---