how to handle null values in sequential file?



how to handle null values in sequential file?..

Answer / satyanarayana

GO to the Format tab in the sequential file then select the
Field defaults option and then select Null field value
option at right side bottom and then provide the
value...........

Is This Answer Correct ?    28 Yes 3 No

Post New Answer

More Data Stage Interview Questions

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,


What is RCP?

2 Answers   TCS,


If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,


What is container and then types?

1 Answers  


1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,






there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,


Differentiate between hash file and sequential file?

0 Answers  


I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,


1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,


What are the differences between datastage and informatica?

0 Answers  


Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,


What is the use of surrogate key stage?

2 Answers  


Categories