Answer / hanug

The degree of parallelism is achieved by configuring the
multiple nodes in the congig file.

In the config files we can specify multiple nodes.

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

---

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

Differentiate between data file and descriptor file?

0 Answers  

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  

---

what is datastage job Monitoring

6 Answers   CTS,

---