Answer Posted / maruthi
DATA STAGE TRIGGERS USED TO CONTROL JOB ACTIVITIES IN JOB
SEQUENCES,IN JOB SEQUENCES STAGES ARE CALLED AS ACTIVITIES
AND LINKS ARE CALLED AS TRIGGERS.
TRIGGERS ARE OF 3 TYPES.)1.0CONDITIONAL,2.)UN-
CONDITIONAL,3.)OTHER WISE.
SO, BY USING TRIGGERS WE CAN CONTROL THE JOB
ACTIVITIES,USUALLY LARGE DWH JOBS DEPENDS ONE 1 OR 2 JOBS
TO GET DATA,SO BY USING THESE TRIGGERS WE CAN GIVE
CONDITION TO RUN POST JOB ONCE IF PREVIOUS ONE RUNS
SUCCESFULLY
Is This Answer Correct ? | 32 Yes | 1 No |
Post New Answer View All Answers
What is "fatal error/rdbms code 3996" error?
Difference between sequential file and data set?
What are the different plug-ins stages used in your projects?
Can we use target hash file as a lookup ?
What is the difference between an operational datastage and a data warehouse?
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 are datastage sequences?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Define Merge?
What is the difference between hashfile and sequential file?
options available in sequence job to run,validate?
what is the difference between == and eq in UNIX shell scripting?
What is the precedence of stage variables,derivations, and constraints?
What are some prerequisites for datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do