Answer / kalpana

costbased and rule based approaches r used as optimization
techniques in improving the performance of queries

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

How do you implement configuration management in Informatica?

1 Answers  

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

explain abt union t/r?

1 Answers   IBM,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

---

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

---

how to use incremental load?

2 Answers   TCS,

---