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
I have a few records just I want to store data in to targets cycling way how?
What is the differentiate between data file and descriptor file?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the different layers in the information server architecture?
Can you define merge?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How many types of views are there in a datastage director?
Define ds designer?
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?
Does datastage support slowly changing dimensions ?
What are the areas of application?
What is aggtorec restructure operator?
What is the different type of jobs in datastage?
What are sequencers?