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
What are the benefits of datastage?
What is the difference between hashfile and sequential file?
Is the value of staging variable stored temporarily or permanently?
What is the difference between in process and inter process?
Difference between data warehousing and olap?
What is difference between join, merge and lookup stage?
What are the different layers in the information server architecture?
What are stage variables and constants?
Define data aggregation?
What is process model?
What are the important features of datastage?
Can you explain tagbatch restructure operator?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the different options associated with dsjob command?
What is usage analysis in datastage?