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


Please Help Members By Posting Answers For Below Questions

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1942


Define oconv () and iconv () functions in datastage?

1112


What is oci?

1082


What are the types of hashed files in data stage

868


which r the connectors used in san?

1977


What all are the different way to run a job?

835


Differentiate between odbc and drs stage?

809


What are the some differences between 7.x and 8.x version of datastage?

997


What are the important features of datastage?

834


How to RD using transformer?

1110


What is job control?

801


What are the types of views in datastage director?

1532


Explain the situation where you have applied SCD in your project?

1784


How many types of hash files are there?

851


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2257