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

TAKE PARALLEL TRANSFORM-DOUBLE CLICK COLUMN FIELD/U WILL
GET DS MACRO,DS FUNCTION/GO TO FUCTIONS/NULL HANDLING/NULL
TO VALUE/HETE U CAN GIVE INPUT FIELD& DEFAULT VALUE.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3245


What is orabulk stage?

1043


How many types of stage?

1172


If you want to use the same piece of code in different jobs, how will you achieve it?

1147


Can you highlight the main features of ibm infosphere information server?

1086


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2202


What is the differentiate between data file and descriptor file?

1355


How one source columns or rows to be loaded in to two different tables?

1120


What is a ds designer?

1068


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 ?

2015


Explain usage analysis in datastage?

1155


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2855


How do you start developing a datastage project?

1101


What is the difference between validated and compiled in the datastage?

1278


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1375