Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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 :(

Question Posted / ddayy

Answers were Sorted based on User's Feedback



hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

Answer / 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

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

Answer / 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

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null va..

Answer / 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

More Data Stage Interview Questions

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

Define APT_CONFIG in Datastage?

0 Answers  

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

What is a merge?

0 Answers  

What is the purpose of pivot stage?

0 Answers  

count number of deptno in a emp table?

2 Answers   IBM,

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,

How you can fix the truncated data error in datastage?

0 Answers  

In Datastage, how you can fix the truncated data error?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories