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

What are the steps required to kill the job in Datastage?

682


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1716


What is the difference between passive stage and active stage?

820


what is ds administrator used for?

719


What are data elements?

657






If you want to use a same piece of code in different jobs, how will you achieve this?

788


How many types of sorting methods are available in datastage?

629


Why do we use link partitioner and link collector in datastage?

679


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1463


Highlight the main features of datastage?

613


what is the use of materialized view?

958


What is difference between symmetric multiprocessing and massive parallel processing?

649


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

735


Difference between ‘validated ok’ and ‘compiled’ in data stage?

666


In Datastage, how you can fix the truncated data error?

640