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

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

Differentiate between datastage and informatica?

0 Answers  

AGGREGATOR default datatype

0 Answers   CTS,

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

What are the repository tables in datastage?

0 Answers  

Define APT_CONFIG in Datastage?

0 Answers  

what is initial load and incremental load

3 Answers   ADP,

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

How to Remove Duplicate using SQL?

0 Answers   CTS,

What are the different kinds of views available in a datastage director?

0 Answers  

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

For more Data Stage Interview Questions Click Here
Categories