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
- 7890 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
project Steps,hits, Project level HArd things,Solved methods?
Which warehouse using in your datawarehouse
Terminate Activity
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the steps needed to create a simple basic datastage job?
Why do you need stage variables?
What is the difference between operational data stage (ods) and data warehouse?
Describe stream connector?
options available in sequence job to run,validate?
how to sort two columns in single job in datastage.
What are the types of containers and how to create them?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the types of containers?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Explain ibm infosphere information server and highlight its main features?
