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

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

how to closeing records after 10,000 records come?

3 Answers  

Highlight the main features of datastage?

0 Answers  

AGGREGATOR default datatype

0 Answers   CTS,

How many areas for files does datastage have?

0 Answers  

How can u write exception handling in seq file????

2 Answers   IBM,

Explain ibm infosphere information server and highlight its main features?

0 Answers  

what is advantages of snowflake when it is used?

3 Answers   IBM,

How and where you used hash file?

0 Answers  

how to add a new records into source?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories