How can we do null handling in sequential files?

Answer Posted / krishnabadimala@gmail.com

we can do null handling in sequential file by using null
field value option.which is available in format tab then we
have to et null field value=<what do u want>

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the third party tools that can be used in datastage?

611


How and where you used hash file?

655


why do u need the IOS upgradation in a FC switch

1868


Explain ibm infosphere information server and highlight its main features?

606


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

3376






How do you register plug-ins?

598


What could be a data source system?

574


What is ibm datastage flow designer?

683


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3501


Explain the situation where you have applied SCD in your project?

1558


Define oconv () and iconv () functions in datastage?

877


Can you define merge?

666


Give an idea of system variables.

587


What is the differentiate between data file and descriptor file?

861


Why we use surrogate key?

697