Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27617 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
take one stage variable
sV: if (IsNull(colum_name) or Column_name='') Then 0 Else 1
and in constraint use
sV=0 (null records will goes to one target)(we can handle null by using stage variable)
sV=1 (not null records will goes to another target)
Plz Correct me, if am wrong......
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
in oracle target stage when we use load option and when we use upsert option?
How do you run datastage job from the command line?
What is the importance of the exception activity in datastage?
What are the main features of datastage?
What is orabulk stage?
What are the differences between datastage and informatica?
Nls stands for what in datastage?
Which algorithm you used for your hashfile?
What is the difference between datastage and informatica?
Notification Activity
How many types of stage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
describe the Steps to confiure a Qlogic switch
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
