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  

---

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 the difference between the local container and shared container?

0 Answers  

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

what is executable in DataStage?

2 Answers  

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---

how to handle null values in sequential file?

1 Answers   HCL,

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

why we use hash file for lookup?

5 Answers  

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

0 Answers  

---