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 :(
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of containers and how to create them?
what is the use of surogate key in datastage
What is the use of datastage designer?
What is the difference between account and directory options ?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is datastage engine?
Which warehouse using in your datawarehouse
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is ds administrator used for?
how to abort the job its matain duplicates?
What is the difference between datastage and informatica?
I have a few records just I want to store data in to targets cycling way how?
What is the command line function to import and export the ds jobs?
What is the flow of loading data into fact & dimensional tables?