Answer / mallika

Sequential file stage doesn't recognize nulls. So in format
tab you will find an option null to value property and there
you can enter any value

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

A flat file 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 this job?

1 Answers   TCS,

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

1 Answers   CTS,

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

What is oci?

1 Answers  

---

difference between server shared container and parallel shared container

6 Answers   CTS,

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1 Answers  

---

how to implement scd2 in datastage 7.5 with lookup stage

1 Answers   TCS,

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1 Answers  

---

Describe stream connector?

1 Answers  

---

what is .dsx files

3 Answers   IBM,

---