i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4
session after 5th session how will you do?
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
wkf--s1----s2----s3---s4---Eventraise
eventwait-----s5
first run execute four sessions successfully eventraise task
give the signal to Event wait task to execute the session 5(S5)
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / usha
by using decission task we can run S5 after running
S1,S2,S3,S4--->decission task --->S5
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / nidhi
we can do one thing also very simple .
s1----\
s2-----\_______|->s5
s3-----/
s4----/
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / davan
First 2 ams r they asked after 5th task execution then will
run.soo...workflow--s5--event wait
event raise--s1--s2--s3--s4
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / chiky
connect the 5th session as first from start task and rest
of the 4 sessions followed by 5th session.
check fail parent option in first(5) session.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vnk
first 4 sessions parallel and using decision task connect 5th session task.
startask--s1
--s2
--s3 decisiontask --s5
--s4
in decision task-properties-all s1-s4 to status=succeeded using (and.
decision task to s5 (linkcondition =true).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vamsi
Write a post session command, touch some filename.trg
Then put event wait task in between session 4 and 5
Make that event wait task to look for created trigger file
And then session 5 starts
| Is This Answer Correct ? | 0 Yes | 0 No |
Separate from an archive server and a powerhouse?
What are the popular informatica products?
without update strategy how to insert &update?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
What are variable ports and list two situations when they can be used?
What are the different threads in DTM process?
what is the main advantage of unconnected lookup
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
In a sequential batch can you run the session if previous session fails?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.