how can we do null handling in sequential files

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

How do u call shellscript/Batch file from DS?

4 Answers   HP,


where we use column generator stage in real time scenario?

5 Answers   TCS,


on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,


1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  


You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,






What is the difference between operational data stage (ods) and data warehouse?

0 Answers  


how to load meta data

2 Answers   IBM,


What is the difference between in process and inter process?

0 Answers  


Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  


Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  


What are constraints and derivations?

0 Answers  


What is the different type of jobs in datastage?

0 Answers  


Categories