Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 28205 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 stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is staging variable?
What is the roundrobin collector?
How do you start developing a datastage project?
Differentiate between hash file and sequential file?
What is the difference between odbc and drs stage?
describe the Steps to confiure a Qlogic switch
What is the difference between informatica and datastage?
What are the different options associated with dsjob command?
How we can covert server job to a parallel job?
how many rows sorted in sort stage by default in server jobs
Why do you need stage variables?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Lookup constraints
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
