Answer / Abhishek Kumar Kashyap

Oracle Bulk Copy (ORABulk) and BCP (Bulk Copy Program) are stages in DataStage used for efficient loading of data into Oracle and SQL Server databases, respectively. These stages allow for bulk insert operations, improving performance when dealing with large amounts of data.

how to get the unique records on multiple columns by using sequential file stage only

3 Answers  

---

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

How you can fix the truncated data error in datastage?

1 Answers  

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

Name the different sorting methods in datastage.

1 Answers  

---

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1 Answers  

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

Differentiate between data file and descriptor file?

1 Answers  

---