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 is exact difference between Parallel Jobs and server Jobs..
whom do you report?
What is ds designer?
How to Remove Duplicate using SQL?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
What is active and passive stage?
What is the difference between informatica and datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How we can covert server job to a parallel job?
job locking methods? How can we unlock the job?
How can you join flat file, oracle as a sources?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?