how can we do null handling in sequential files

Answers were Sorted based on User's Feedback



how can we do null handling in sequential files..

Answer / kiran

go to target level of Seq_file ,click on Format Tab then
click on field format and select null field values=0.

Is This Answer Correct ?    19 Yes 2 No

how can we do null handling in sequential files..

Answer / venkat

go to target level of sequence file,click on format tab and then click field format select and put the value=''

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Stage Interview Questions

WHAT are unix quentios in datastage

2 Answers   TCS,


in oracle target stage when we use load option and when we use upsert option?

0 Answers  


how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,


What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  


Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,


one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,


What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  


A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,


WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


what are the different type of errors in datastage?

2 Answers   Wipro,


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

0 Answers  


What are orabulk and bcp stages?

0 Answers  


Categories