How can we do null handling in sequential files?
Answer Posted / naga
While importing the data we can specifie nullable 'yes' in define tab.
or
In format tab we can specifie the Final delimeter as 'null'.
Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How can we improve performance of data stage jobs?
What is the difference between Datastage 7.5 and 7.0?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Explain Quality stage?
What are orabulk and bcp stages?
What all are the different way to run a job?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the areas of application?
How to read multiple files using a single datastage job if files have the same metadata?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
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?
What are the benefits of datastage?
What is the purpose of pivot stage and types of containers in datastage