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

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

Give an idea of system variables.

0 Answers  

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

What is the use of Row generator stage?

2 Answers  

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

How do u view log file for a particular job?

6 Answers   HP,

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

what is A Datastage?

2 Answers  

How did you reconcile source with target?

2 Answers   HP,

For more Data Stage Interview Questions Click Here
Categories