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

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,


source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,


What are the processing stages?

0 Answers  


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,


how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,






difference between function and procedure...

1 Answers   IBM,


If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,


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 can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,


CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,


souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  


can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,


Categories