why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

What is the target load order?

3 Answers   HCL, Informatica,

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

What are the connected or unconnected transforamations?

2 Answers  

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

Define Pmrep command?

0 Answers  

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---