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

in the column extended properties set the desired value if
it is null

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you generate sequence number in datastage?

1101


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

4131


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1220


What are the types of containers in datastage?

1193


What is the purpose of interprocessor stage in server jobs?

2233


Describe the main features of datastage?

1078


what are the devoleper roles in real time? plz tell i am new to datastage....

2164


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1509


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2266


What is process model?

1986


What are the job parameters?

1223


Does datastage support slowly changing dimensions ?

1110


Why fact table is in normal form?

1260


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873