Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27981 Views
- I also Faced
- E-Mail Answers
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
describe the Steps to confiure a Qlogic switch
What is the difference between server job and parallel jobs?
What is difference between join, merge and lookup stage?
Differentiate between Join, Merge and Lookup stage?
What is the difference between account and directory options ?
What is the use of datastage director?
What steps should be taken to improve Datastage jobs?
what is the use of materialized view?
What is the difference between datastage and informatica?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the types of views in datastage director?
How to manage date conversion 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 job control?
What is the different type of jobs in datastage?
