how to handle null values in sequential file?

1 Answers   HCL,

---

What are the areas of application?

0 Answers  

---

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,

---

Difference between sequential file and data set?

0 Answers  

---

Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,

---

How many areas for files does datastage have?

0 Answers  

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

---

Tell me the syntax of Configuration file?

1 Answers  

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---