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
- 5986 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 |
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
Distinguish between informatica & datastage. Which one would you choose and why?
what is combinability and non combinability?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
What is lookup table?
1)Source file contains one record, I want 100 records in target file.
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
What are the types of views in datastage director?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
Why we need datasets ratherthan sequential files?
What is the purpose of interprocessor stage in server jobs?
What are data elements?
Teradata 
