how can u handle null values in transformer stage.

Answer Posted / rajeshchunduri

in transformer we have null handling functions in that by
using null to zero we can handle null.

chunduri

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1177


Describe stream connector?

1066


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2674


Differentiate between hash file and sequential file?

813


What are the processing stages?

867


how to delete one row in target dataset

2860


How to reverse the string using SQL?

1159


How and where you used hash file?

916


how many rows sorted in sort stage by default in server jobs

3770


What are the different kinds of views available in a datastage director?

815


What is the purpose of interprocessor stage in server jobs?

1977


How will you move hashed file from one location to another location?

1911


What is the difference between odbc and drs stage?

858


How do you import and export the datastage jobs?

945


How rejected rows are managed in datastage?

1217