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
How we can covert server job to a parallel job?
Can you define merge?
How many Key we can define in remove duplicate stage?
Explain connectivity between datastage with datasources?
sed,awk,head
What is process model?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the components of datastage?
Lookup constraints
how to abort the job its matain duplicates?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the different type of jobs in datastage?
What is usage analysis in datastage?
Define Data Stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu