Answer / sriram

Database contains data called production data mostly and we can do operations but not recommended which is a performance issue and is always busy with application data
where as in DW,the data which we maitain is called historical data, on which we can play around.

How to initialize environment variables?

4 Answers   Infosys,

---

count number of deptno in a emp table?

2 Answers   IBM,

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

What is the sortmerge collector?

0 Answers  

---

What can we do with datastage director?

0 Answers  

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

What is the difference between hashfile and sequential file?

0 Answers  

---

how to define satge variables in transformer stage

2 Answers  

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

How and where you used hash file?

0 Answers  

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---

How we can covert server job to a parallel job?

0 Answers  

---