tell me abt Datastage trigger?
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 is ds administrator used for?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
Please tell me What is difference between 8.0 and 8.1
How do you remove duplicate values in datastage?
How one source columns or rows to be loaded in to two different tables?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
how can or from where we can get reference data in scd type2 implementation?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
on how many columns we can perform aggregation in the aggregator stage?