A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

Difference between sequential file and data set?

0 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---