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...

How do u set a default value to a column if the column value
is NULL?

Answer Posted / jayakumar

IF ISNULL(Column_Name.field) THEN default value ELSE
(Column_Name.field)

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1135


What is a ds designer?

1024


What is the difference between datastage and informatica?

1058


Differentiate between operational datastage (ods) and data warehouse?

1115


How we can covert server job to a parallel job?

1058


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3732


Can you explain repository tables in datastage?

1339


Where the datastage stored his repository?

1018


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

749


What is merge stage?

1224


in oracle target stage when we use load option and when we use upsert option?

2201


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2924


what is repositery?

1766


How you Implemented SCD Type 1 & Type 2 in your project?

4072


What are the difference types of stages?

1132