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


Please Help Members By Posting Answers For Below Questions

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

1811


How can we improve performance of data stage jobs?

620


What is the difference between Datastage 7.5 and 7.0?

679


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3387


Explain Quality stage?

673






What are orabulk and bcp stages?

653


What all are the different way to run a job?

646


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...

3764


What are the areas of application?

664


How to read multiple files using a single datastage job if files have the same metadata?

744


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)

1905


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?

1788


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?

1761


What are the benefits of datastage?

732


What is the purpose of pivot stage and types of containers in datastage

619