How can we do null handling in sequential files
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kak
In sequential file we have one property null to value or
null to zero using that we can handle the nulls.
Is This Answer Correct ? | 4 Yes | 2 No |
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
Describe the architecture of datastage?
which dim, fact tables used in bank domain
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
what is .dsx files
What are transforms and what is the differenece between routines and transforms?
What is the difference between in process and inter process?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How can we run same job in 1 day 2 times
What is the purpose of pivot stage?
What is the Difference Between DataStage 7.5 version and 8.1 Version?