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
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
whom do you report?
Where do you see different stages in the designer?
Explain the situation where you have applied SCD in your project?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
On which interface you will be working as a developer?
why do u need the IOS upgradation in a FC switch
Define orabulk and bcp stages?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is size of a transaction and an array means in a datastage?
How do you start developing a datastage project?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the different plug-ins stages used in your projects?
how to delete one row in target dataset
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.