Answer Posted / bharath

SERVER JOBS
->Runs on single node
->Executes on DS Server Engine
->Handles less volume of data
->Slow data processing
->Having less no. of components(i.e, palette)
->Compiled into Basic language.

PARALLEL JOBS
->Runs on multiple nodes.
->Executes on DS parallel engine.
->Handles Huge volume of data
->Faster data processing.
->Having more no. of components
->Compiled into OSH(orchestrate shell script) except transformer( C++ and OSH )

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

2207

---

Can you highlight the main features of ibm infosphere information server?

1046

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1001

---

What is merge stage?

1228

---

What is the difference between validated and compiled in the datastage?

1195

---

Why fact table is in normal form?

1150

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1173

---

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

888

---

What are sequencers?

1059

---

What is job control?

1035

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1097

---

What is use Array size in datastage

1721

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1333

---

What is the command line function to import and export the ds jobs?

1098

---

Lookup constraints

1202

---