Interested to Buy Any Domain ? << Click Here >> for more details...
How can we do null handling in sequential files
- 3 Answers
- 15689 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
What are the processing stages?
How to read the length of word in unix?
What is a datastage job?
What is a merge in datastage?
What are the different layers in the information server architecture?
What is the difference between server job and parallel jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
On which interface you will be working as a developer?
What are the primary usages of datastage tool?
What is oci?
What are the different options associated with dsjob command?
What is meta stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are data elements?
