Interested to Buy Any Domain ? << Click Here >> for more details...
tell me abt Datastage trigger?
- 1 Answers
- 20061 Views
- HP, IBM, I also Faced
- E-Mail Answers
Answer / 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 |
What are the job parameters?
Can you explain repository tables in datastage?
Display all files which have size more 3KB in given directory/folder.
Can you explain tagbatch restructure operator?
What are the types of containers and how to create them?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
client know skid info?
How we can convert rows to columns in datastage?
How to generate surrogate key without using surrogate key stage?
How do u set a default value to a column if the column value is NULL?
How do you remove duplicate values in datastage?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
Teradata 
