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

what is flow of project?

1561


Why do you need stage variables?

668


What are the steps required to kill the job in Datastage?

688


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1934


Highlight the main features of datastage?

619






Name the different sorting methods in datastage.

617


What is the precedence of stage variables,derivations, and constraints?

604


which r the connectors used in san?

1798


What is staging variable?

626


Define project in datastage?

670


Could anyone give brief explanation bout datastage admin

1975


Define APT_CONFIG in Datastage?

668


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

1476


How to reverse the string using unix?

2815


How to RD using transformer?

868