Interested to Buy Any Domain ? << Click Here >> for more details...
How can we do null handling in sequential files
- 3 Answers
- 15372 Views
- Reliance, I also Faced
- E-Mail Answers
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 create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Why do you need stage variables?
Define Routines and their types?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Difference between server jobs & parallel jobs?
what are the devoleper roles in real time? plz tell i am new to datastage....
What all are the different way to run a job?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Why fact table is in normal form?
What are the types of jobs we have in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is staging variable?
How do you import and export the datastage jobs?
Difference between sequential file and data set?
How do u convert the columns to rows in datastage?
