Interested to Buy Any Domain ? << Click Here >> for more details...
Is there no issue when you try to convert a NOt null column
in nullable and vice versa in aggregator styage and
transformer stage? When I tried i got the warnings but in a
running code I can see such type of scenarios. Please
explain
- 2 Answers
- 6212 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
When
col is converted from not null to null and data coming has
null or not null values then NO Problem.
But col is NULL constraint and converted to Not NULL then
two cases
i) when data coming from source has no NULL values then no
problem.
ii)when data coming from source has NULL values then the job
simply ABORTS.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
Describe stream connector?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Highlight the main features of datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are system variables and sequencers in datastage
What is merge stage?
What are routines in datastage? Enlist various types of routines.
Difference between sequential file and data set?
What are the different layers in the information server architecture?
What are stage variables and constants?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the use of datastage director?
