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 / 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 is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,


Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,


What are the features of datastage flow designer?

0 Answers  


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,






Why do you need stage variables?

0 Answers  


hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  


difference between function and procedure...

1 Answers   IBM,


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  


why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,


What all are the different way to run a job?

0 Answers  


which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


Categories