how to handle null values using transformer stage?



how to handle null values using transformer stage?..

Answer / mallika

Sequential file stage doesn't recognize nulls. So in format
tab you will find an option null to value property and there
you can enter any value

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Data Stage Interview Questions

How can we run same job in 1 day 2 times

4 Answers   IBM,


If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  


Why we use surrogate key?

0 Answers  


Terminate Activity

0 Answers   CTS,






Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,


How the ipc stage work?

0 Answers  


How many types of views are there in a datastage director?

0 Answers  


What are operators in datastage?

1 Answers  


Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  


How can we run same job in 1 day 2 times

7 Answers   IBM,


eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,


Categories