How can we do null handling in sequential files

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a few records just I want to store data in to targets cycling way how?

2135


What is the differentiate between data file and descriptor file?

1117


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1186


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

1840


What are the different layers in the information server architecture?

867


Can you define merge?

881


Explain the datastage parallel extender (px) or enterprise edition (ee)?

989


How many types of views are there in a datastage director?

1067


Define ds designer?

1008


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2020


Does datastage support slowly changing dimensions ?

853


What are the areas of application?

913


What is aggtorec restructure operator?

1104


What is the different type of jobs in datastage?

737


What are sequencers?

843