1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

how can u handle null values in transformer stage.

7 Answers  

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

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

6 Answers   IBM,

---

What are system variables and sequencers in datastage

0 Answers  

---

how will u design file watch jobs?

2 Answers  

---

How a server job can be converted to a parallel job?

0 Answers  

---

Enlist various types of routines in datastage.

0 Answers  

---

What are the important features of datastage?

0 Answers  

---

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---