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
- 6560 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 |
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
what is normalization and denormalization
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
why we use parameters instead of hard code in datastage
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
What are some different alternative commands associated with "dsjob"?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
On which Dimension Table you implemented SCD Type in your Project
Name the different types of Lookups in Datastage?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
Teradata 
