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

What are the benefits of datastage?

972


What is the difference between hashfile and sequential file?

979


Is the value of staging variable stored temporarily or permanently?

800


What is the difference between in process and inter process?

928


Difference between data warehousing and olap?

859


What is difference between join, merge and lookup stage?

875


What are the different layers in the information server architecture?

889


What are stage variables and constants?

943


Define data aggregation?

893


What is process model?

1767


What are the important features of datastage?

853


Can you explain tagbatch restructure operator?

964


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2669


What are the different options associated with dsjob command?

1221


What is usage analysis in datastage?

1081