how can u handle null values in transformer stage.

Answer Posted / sailaja

Hi,

For Null handling in transformer you can use the below function dependind on ur requirement

1. Nulltoempty
2. Nulltozero
3.Nulltovalue

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1621


To see hidden files in LINIX?

939


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2002


What are the types of jobs we have in datastage?

663


What are the different type of jobs in datastage?

600






Enlist various types of routines in datastage.

636


How rejected rows are managed in datastage?

909


What are the features of datastage flow designer?

623


How do you register plug-ins?

593


Define Merge?

870


How to Remove Duplicate using SQL?

833


What is a folder? Difference types of stages?

617


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

827


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

591


What is the difference between the local container and shared container?

641