How can we do null handling in sequential files?

Question Posted / tallamaheshgoud

3 Answers
17810 Views
Reliance, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we do null handling in sequential files?..

Answer / 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

How can we do null handling in sequential files?..

Answer / dheeraj

we can do null handling in sequential file by using null
field value option.which is available in format tab.

Is This Answer Correct ?

1 Yes

0 No

How can we do null handling in sequential files?..

Answer / 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

More Data Stage Interview Questions

What are some prerequisites for datastage?

0 Answers

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers IBM,

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers Infosys,

what are fact tables and dimension tables? give example assuming one table.

3 Answers IBM,

What are the functionalities of link partitioner?

0 Answers

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers

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

0 Answers

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers CTS,

how to call routines in stages?

3 Answers ME,

How complex jobs are implemented in datstage to improve performance?

0 Answers

For more Data Stage Interview Questions Click Here