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 / hk

let make it more simpler use NullToValue() or NullToempty()
function ,

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How rejected rows are managed in datastage?

1574


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1349


Where the datastage stored his repository?

1140


What are data elements?

1235


What are the types of containers?

1310


Different ways a project can be moved to production ?...example ….export-import and Version control.

2501


What is the command line function to import and export the ds jobs?

1190


How do you generate sequence number in datastage?

1140


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074


What are the primary usages of datastage tool?

1128


What is apt_config in datastage?

1194


How and where you used hash file?

1222


What steps should be taken to improve Datastage jobs?

1120


How do you run datastage job from the command line?

1129


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

1208