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
- 6121 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
What is active and passive stage?
What are the difference types of stages?
What are routines in datastage? Enlist various types of routines.
Define APT_CONFIG in Datastage?
What is the purpose of pivot stage?
How will you move hashed file from one location to another location?
What is the purpose of interprocessor stage in server jobs?
What is ibm datastage flow designer?
Why do you need stage variables?
State the difference between an operational datastage and a data warehouse?
What is a ds designer?
Describe link sort?
What is the difference between datastage and datastage tx?
Can you implement SCD2 using join, transformer and funnel stage?
Could anyone give brief explanation bout datastage admin
