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

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  


Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,


How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  


what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,


what is sparse lookup?

7 Answers   IBM,






file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  


How do you remove duplicate values in datastage?

0 Answers  


What a datastage macro?

0 Answers  


What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  


Define data aggregation?

0 Answers  


hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,


how to sort two columns in single job in datastage.

1 Answers   TCS,


Categories