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

What a datastage macro?

641


Can you filter data in hashed file?

3353


Terminate Activity

842


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3505


What all the types of jobs you developed?

672






Can you explain repository tables in datastage?

909


Can you explain players in datastage?

713


how to abort the job its matain duplicates?

2112


what is the use of surogate key in datastage

1825


What is the difference between hashfile and sequential file?

728


Define APT_CONFIG in Datastage?

668


What is the difference between informatica and datastage?

660


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

2547


Explain Quality stage?

673


Define Job control?

681