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
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Name the different sorting methods in datastage.
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are stage variables and constants?
What is staging variable?
What are the features of datastage flow designer?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Explain entity, attribute and relationship in datastage?
How to read the length of word in unix?
Why fact table is in normal form?
What is the difference between datastage and informatica?
Describe link sort?
What is the purpose of pivot stage and types of containers in datastage
Name the third party tools that can be used in datastage?
why do u need the IOS upgradation in a FC switch