in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

---

Define Job control?

0 Answers  

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---

Wat is pre-load in Hashed file

1 Answers   Patni,

---

what is the definitions for Datawarehose and Datamart?

4 Answers  

---