how to handle null values in sequential file?

1 Answers   HCL,

---

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,

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

Define data aggregation?

0 Answers  

---

why dataset ?

2 Answers  

---

What are the stages in datastage?

0 Answers  

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

---

Differentiate between datastage and datastage tx?

0 Answers  

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

---