Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27616 Views
- I also Faced
- E-Mail Answers
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
What is meta stage?
How can one find bugs in job sequence?
What are the various kinds of containers available in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is a datastage job?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
options available in sequence job to run,validate?
How you Implemented SCD Type 1 & Type 2 in your project?
Give an idea of system variables.
Can you filter data in hashed file?
What are some different alternative commands associated with "dsjob"?
Define meta stage?
What is the difference between passive stage and active stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is ds designer?
