How can we do null handling in sequential files

Answers were Sorted based on User's Feedback



How can we do null handling in sequential files..

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

Is This Answer Correct ?    5 Yes 2 No

How can we do null handling in sequential files..

Answer / kak

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

Is This Answer Correct ?    4 Yes 2 No

How can we do null handling in sequential files..

Answer / hari

YA UR EXACTLY RIGHT PHANI.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Data Stage Interview Questions

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


Describe the architecture of datastage?

0 Answers  


which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  


what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,


what is .dsx files

3 Answers   IBM,


What are transforms and what is the differenece between routines and transforms?

0 Answers  


What is the difference between in process and inter process?

0 Answers  


hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,


How can we run same job in 1 day 2 times

4 Answers   IBM,


What is the purpose of pivot stage?

0 Answers  


What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,


Categories