how can we do null handling in sequential files

Question Posted / vijayp.dw

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

More Data Stage Interview Questions

plz tell me some dimentional and fact table names in banking project?

With out using Funnel Stage, how to populate the data from different sources to single target

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

what is sparse lookup?

How to Remove Duplicate using SQL?

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

when we have to go for a sequential file stage & for a dataset in datastage?

Explain ibm infosphere information server and highlight its main features?

Name the third party tools that can be used in datastage?

how do u capture duplicates through sort & transformer

how to configure databases through datastage

For more Data Stage Interview Questions Click Here