how can u handle null values in transformer stage.
Answer Posted / subhash
null handling in transformer in two ways
one for
1. identifing the Null values
2. Remove the Null values
1.Ans: by using Null handing function
2.Ans: By using Constrains we can Remove the Null Values Rows
In transformer
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are the errors,warnings in datastage
How many types of stage?
What is difference between server jobs & parallel jobs?
What are datastage sequences?
How to find value from a column in a dataset?
Differentiate between datastage and datastage tx?
How do you start developing a datastage project?
What is meta stage?
what is repositery?
What is the flow of loading data into fact & dimensional tables?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Where the datastage stored his repository?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the use of hoursfromtime() function in transformer stage 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