How can we do null handling in sequential files
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 |
Is possible to create skid in dim,fact tables?
how can u handle null values in transformer stage.
To see hidden files in LINIX?
why do u need the IOS upgradation in a FC switch
how to write server Routine coding?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Describe the main features of datastage?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
What is apt_config in datastage?
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
what is datastage job Monitoring
What is "fatal error/rdbms code 3996" error?