hi everbody,
i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"
hi everbody,
i have a problem in my project..
Native Error Code: -407 "Assignment of a null value to a not null column"
i have no idea, what should i do..please help :(
- 3 Answers
- 7197 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sagnik mukherjee
Hi,
You can try one thing.In the file stage where you are reading the file, there in columns metadata tab, set Null as 'Yes' for that particular column and do the same for the other stages too in that job.
Sometimes if you are getting null value from source but your column is set as 'No' for Null then this error can come.
| Is This Answer Correct ? | 1 Yes | 0 No |
Seq file can not hold the NULL value. Convert all Null values to '' in stage
http://goo.gl/atN4AT
www.datagenx.net
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nish
your schema contains the target column as Nullable-No.
you need to change that. Enable Yes/ Don't Know for that
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between server jobs & parallel jobs?
What is process model?
explain unit testing,systemtesting,integrated testing
Terminate Activity
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How can u write exception handling in seq file????
how do u reduce warnings
What steps should be taken to improve Datastage jobs?
Teradata 
