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 )

Can you filter data in hashed file?

3772

---

What are the features of datastage flow designer?

1039

---

Define Job control?

1146

---

what is flow of project?

2002

---

CHANGE CAPTURE

1300

---

State the difference between an operational datastage and a data warehouse?

1131

---

What is size of a transaction and an array means in a datastage?

1313

---

what is use of SDR function?

5173

---

What is difference between server jobs & parallel jobs?

1038

---

how to add a new records into source?

2000

---

What are the difference types of stages?

1215

---

How do y read Sequential file from job control?

15960

---

How one source columns or rows to be loaded in to two different tables?

1130

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

---

Can you explain players in datastage?

1199

---