how can we do null handling in sequential files

Question Posted / vijayp.dw

2 Answers
8710 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 / kiran

go to target level of Seq_file ,click on Format Tab then
click on field format and select null field values=0.

Is This Answer Correct ?

19 Yes

2 No

how can we do null handling in sequential files..

Answer / venkat

go to target level of sequence file,click on format tab and then click field format select and put the value=''

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Data Stage Interview Questions

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers TCS,

Terminate Activity

0 Answers CTS,

How can one find bugs in job sequence?

0 Answers

What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers IBM,

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers Wipro,

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers

what is datastage job Monitoring

6 Answers CTS,

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers

Differentiate between datastage and informatica?

0 Answers

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers TCS,

For more Data Stage Interview Questions Click Here