how can we do null handling in sequential files

Question Posted / vijayp.dw

2 Answers
8823 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

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers Patni,

which unix commands mostly used in datastage

3 Answers HSBC,

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers Cap Gemini,

What are the important features of datastage?

0 Answers

how do u reduce warnings

1 Answers CGI,

How to add zero "0" before record in a field?

4 Answers

how do you pass parameters in a script?

1 Answers L&T,

what is A Datastage?

2 Answers

Main Function of the Staging area in DWH ?

2 Answers

what is the diff between sequential file and fileset stages?

3 Answers

what is the unix script to run the job? Please mention commands which we use often?

3 Answers TCS,

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers Infotech,

For more Data Stage Interview Questions Click Here