how can u handle null values in transformer stage.

Answer Posted / prabhath.p

by using 1).Null to value(input column)
2.null to empty(input column)
3.if is null(input column_then
three commands are there in transformers for null handling

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define merge?

874


How rejected rows are managed in datastage?

1194


Can you filter data in hashed file?

3562


Explain the importance of surrogate key in data warehousing?

935


How do you import and export the datastage jobs?

932


What are stage variables?

894


How can we improve performance of data stage jobs?

798


In Datastage, how you can fix the truncated data error?

860


What is a ds designer?

856


Describe stream connector?

1048


What are the functionalities of link collector?

845


What can we do with datastage director?

917


Where do the datastage jobs get stored?

958


Demonstrate experience in maintaining quality process standards?

2182


What are the components of ascential data stage?

880