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
- 6015 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
1) there is no issue when you are converting NOT NULL column to NULLABLE column even if get null data from source.
2) But when you are converting nullable column to NOT nullable column also you will not get any issue if you get the NOT NULL data from source,
if you get nullable data from source then job will ABORT.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Differentiate between odbc and drs stage?
How can you find out whether datastage process is running or not in unix?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
what are the types of nodes
data stores in which location while using data set stage as the target?
what is factless fact table?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
How to convert alpha Numeric values to alpha using functions?
Define orabulk and bcp stages?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
how many stages are there in Datastage... Please clarify mee??
Define repository tables in datastage?
Teradata 
