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

how can u connect the client system directly at any time?

1 Answers   IBM,

---

Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

How a routine is called in datastage job?

0 Answers  

---

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

---

On which interface you will be working as a developer?

0 Answers  

---

How do u convert the columns to rows in datastage?

0 Answers  

---

Can you highlight the main features of ibm infosphere information server?

0 Answers  

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

Differentiate between Join, Merge and Lookup stage?

0 Answers  

---

How can u write exception handling in seq file????

2 Answers   IBM,

---