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

2 Answers   UHG,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

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

9 Answers  

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

How many types of sorting methods are available in datastage?

0 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---