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
What are the steps required to kill the job in Datastage?
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
What is the difference between odbc and drs stage?
Define orabulk and bcp stages?
Is possible to create skid in dim,fact tables?
How complex jobs are implemented in datstage to improve performance?
Differentiate between datastage and datastage tx?
Is the value of staging variable stored temporarily or permanently?
Explain datastage architecture?
Name the different sorting methods in datastage.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is quality stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain how a source file is populated?
How we can covert server job to a parallel job?