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
On which interface you will be working as a developer?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
root tree will find which is server job and which is parallel job?
Differentiate between Join, Merge and Lookup stage?
What is difference between symmetric multiprocessing and massive parallel processing?
Can you explain engine tier in information server?
Define data aggregation?
What is difference between join, merge and lookup stage?
What are the job parameters?
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.
What is the command line function to import and export the ds jobs?
How the ipc stage work?
What is the difference between passive stage and active stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How do you start developing a datastage project?