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

Is there no issue when you try to convert a NOt null column
in nullable and vice versa in aggregator styage and
transformer stage? When I tried i got the warnings but in a
running code I can see such type of scenarios. Please
explain

Question Posted / neha garg

Answers were Sorted based on User's Feedback



Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregat..

Answer / subhash

1) there is no issue when you are converting NOT NULL column to NULLABLE column even if get null data from source.

2) But when you are converting nullable column to NOT nullable column also you will not get any issue if you get the NOT NULL data from source,
if you get nullable data from source then job will ABORT.

Is This Answer Correct ?    2 Yes 0 No

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregat..

Answer / shar

When
col is converted from not null to null and data coming has
null or not null values then NO Problem.

But col is NULL constraint and converted to Not NULL then
two cases
i) when data coming from source has no NULL values then no
problem.
ii)when data coming from source has NULL values then the job
simply ABORTS.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How many types of stage?

0 Answers  

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

What is a range lookup?

2 Answers   IBM,

what are the different type of errors in datastage?

2 Answers   Wipro,

What is merge stage?

0 Answers  

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

What are the types of hashed files in data stage

0 Answers  

What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories