informatica - How to Rerun the Failed Sessions Alone in a Workflow -


i have wf contains 10 sessions. 6 out of 10 sessions got succeeded, when ran wf. need run failed 4 sessions when run wf again, shouldn't rerun succeeded sessions. please suggest me how achieve this.

note: using sqlserver source , oracle target.

the same thread/question present details not understanding properly

i tried following

a) define parameter restart_indicator (it can have 2 values 'y' in restart situation, 'n' otherwise.

que : how give 2 values parameter (parameter & variable in mapping tool bar)

b) define run table work-flow name + session name key. c) @ start of workflow run initialize entries associated work flow when restart_indicator = 'n' d) every time session executes , update run table entry workflow session combination. e) every session have conditional execution condition being i) restart_indicator = 'n' or restart_indicator = 'y' , run_table entry workflow session indicates session has not completed successfully.

que: how define conditional execution begin failed session re-start? please elaborate little bit.

thanks

this post on youtube gives explanation of how conditionally start session.

in case, need

  1. create workflow variable each of 10 sessions, make these persistent , initialize 0

  2. create task after each session updates it's corresponding workflow variable , set it's value 1, task should run if session completes without error.

  3. before session starts, need add condition checks it's workflow variable 0, start it.

  4. in addition, need add task in beginning of workflow check 10 workflow variables (1 each session) , if 1, set 0. ensure next time run workflow start, if sessions completed previous time.

hope helps.


Comments

Popular posts from this blog

authentication - Mongodb revoke acccess to connect test database -

r - Update two sets of radiobuttons reactively - shiny -

ios - Realm over CoreData should I use NSFetchedResultController or a Dictionary? -