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 / datastage4you
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 |
Post New Answer View All Answers
CHANGE CAPTURE
What are the functionalities of link partitioner?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to write server Routine coding?
Explain connectivity between datastage with datasources?
What are the various kinds of the hash file?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are system variables and sequencers in datastage
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
Define repository tables in datastage?
On which interface you will be working as a developer?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define ds designer?
What are routines in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?