Answer Posted / subhash

In the designer, After Compiling the job and then click on
run.in the Job run options, u will find 3 TABs :Parameters,
Limits, General. Go to Limits TAB, select the "Abort Job
after" and change it to 100. after 100 warnings(errors) the
job will be aborted.
by default it will set to 50
warnings.

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2323

---

What is the difference between datastage and informatica?

1175

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1131

---

How do you remove duplicate values in datastage?

1194

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3290

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2868

---

What is the difference between operational data stage (ods) and data warehouse?

1292

---

How to manage date conversion in Datastage?

1179

---

Can you explain kafka connector?

1371

---

Differentiate between hash file and sequential file?

1120

---

How many types of sorting methods are available in datastage?

1113

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

964

---

How to read the length of word in unix?

1433

---

What is the different type of jobs in datastage?

1023

---

What is the importance of the exception activity in datastage?

1111

---