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 to implement complex jobs in data stage?
How many areas for files does datastage have?
Where the datastage stored his repository?
what is the use of materialized view?
How do you schedule or monitoring the job?
How complex jobs are implemented in datstage to improve performance?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are routines in datastage?
EXPLAIN SCD
What are the partitioning techniques available in link partitioner?
What is size of a transaction and an array means in a datastage?
What are the functionalities of link partitioner and link collector?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the types of jobs we have in datastage?
State the difference between an operational datastage and a data warehouse?