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
What are the steps needed to create a simple basic datastage job?
How to read the length of word in unix?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the types of jobs we have in datastage?
Explain Quality stage?
How to reverse the string using unix?
what is the use of materialized view?
describe the Steps to confiure a Qlogic switch
What is the purpose of pivot stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is ibm datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
State the difference between an operational datastage and a data warehouse?