Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7660 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Describe routines in datastage? Enlist various types of routines.
How do you schedule or monitoring the job?
What is a folder? Difference types of stages?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Difference between in process and inter process?
What is the difference between hashfile and sequential file?
Can we use target hash file as a lookup ?
What are datastage sequences?
What is a quality stage in datastage tool?
Can you explain how could anyone drop the index before loading the data in target in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is a ds designer?
What is the difference between datastage and datastage tx?
What are the types of containers and how to create them?
what is the custome stage in datastage? how can we impliment that one? plz tell me
