Answer / Prashant Kumar Srivastava

DataStage can connect to various data sources like databases, flat files, and cloud storage. Connections are established using adapters provided by DataStage. For example, the DB2 adapter is used for connecting to a DB2 database.

count number of deptno in a emp table?

2 Answers   IBM,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

What is aggtorec restructure operator?

1 Answers  

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

What is active and passive stage?

1 Answers  

---

what is a message handler

3 Answers   IBM,

---

why dataset ?

2 Answers  

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

1 Answers  

---

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  

---

What is job control?

1 Answers  

---