Answer / phani kumar

Sequential file doesn't handle nulls. If the file contains
nulls, then it gives records while reading the file by using
sequential stage,only records which are not having nulls.

In order to handle nulls, there is a option available in
seq.file as NULL TO VALUE. Here, we can give any value for
replacing of Nulls.

Then, DS Engine will consider those symbols are nulls while
reading the data from sequential file.

Thanks and regards,
Phani kumar

Answer / kak

In sequential file we have one property null to value or
null to zero using that we can handle the nulls.

Answer / hari

YA UR EXACTLY RIGHT PHANI.

when will you go for dataset and fileset?

2 Answers   Accenture,

---

types of errors in datastage?

2 Answers   Reliance,

---

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  

---

Describe the main features of datastage?

0 Answers  

---

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,

---

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

0 Answers   CTS,

---

What are the types of containers?

0 Answers  

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

How many areas for files does datastage have?

0 Answers  

---