what is SMP AND MPP?

8 Answers  

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,

---

What is partitioning? Explain different types of partitioning?

0 Answers  

---

if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  

---

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---

what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers  

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

---

What is granularity? Please explain with example

1 Answers   IBM,

---

What is a lookup table in etl?

0 Answers  

---

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  

---

what are the production issues in datastage?

0 Answers  

---