Answer / nupur

Austosys Scheduling tool

whom do you report?

0 Answers   NTT Data,

---

What are data elements?

0 Answers  

---

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)

0 Answers  

---

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

---

what is initial load and incremental load

3 Answers   ADP,

---

What is the project in datastage?

0 Answers  

---

What is mapping?

3 Answers  

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

Describe link sort?

0 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---