How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 34186 Views
- HP, I also Faced
- E-Mail Answers
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
What are the areas of application?
What is active and passive stage?
What is the difference between odbc and drs stage?
Notification Activity
On which interface you will be working as a developer?
Can you explain repository tables in datastage?
Give an idea of system variables.
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?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How one source columns or rows to be loaded in to two different tables?
How many types of hash files are there?
What is the difference between server job and parallel jobs?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
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.
Is the value of staging variable stored temporarily or permanently?
