How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 34212 Views
- HP, I also Faced
- E-Mail Answers
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
Does datastage support slowly changing dimensions ?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the components of datastage?
What are the types of hashed files in data stage
Explain usage analysis in datastage?
What are the types of views in datastage director?
Differentiate between operational datastage (ods) and data warehouse?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is meta stage?
What is the flow of loading data into fact & dimensional tables?
Why we use surrogate key?
what are the devoleper roles in real time? plz tell i am new to datastage....
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Describe the architecture of datastage?
What is process model?
