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.

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

which r the connectors used in san?

0 Answers  

---

How to add zero "0" before record in a field?

4 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers   HCL,

---

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

Explain entity, attribute and relationship in datastage?

0 Answers  

---

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

---

describe the Steps to confiure a Qlogic switch

0 Answers   IBM,

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---

What is the roundrobin collector?

0 Answers  

---