How can we do null handling in sequential files
- 3 Answers
- 14403 Views
- Reliance, I also Faced
- E-Mail Answers
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 |
how to handle null values in sequential file?
What is RCP?
how to transfer file from one system to another system in unix? which cmd to be use?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
how to convert rows into columns
How can we do null handling in sequential files
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
How one source columns or rows to be loaded in to two different tables?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
how can find maximum salary by using Remove duplicate stage?
What are the functionalities of link partitioner and link collector?
what is the unix script to run the job? Please mention commands which we use often?
Teradata 
