Interested to Buy Any Domain ? << Click Here >> for more details...
1,If there are 3 workflows are running and if 1st workflow
fails then how could we start 2nd workflow or if 2nd
workflow fails how could we start 3rd workflow?
- 4 Answers
- 17311 Views
- CompuSoft, EDS, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
When 3 workflows are running sequentially,we can definitely
give the dependancy condition by using LINK condition
between the first two workflows as "Failed".
i.e. the second workflow gets started only when first
workflow is failed and same can be applied between second
and third workflows.
Guys any suggestions please let me know.
Thanks,
James.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / abhinav prakash
1.We can have a command task at the end of 1st and 2nd workflow.
2.the command task from the first wf will send out a trigger
file for the 2nd workflow.
3.we can use event wait task before the 2nd wf and it ll
wait for the trigger file from the frst wf and once its
available will intiate the 2nd wf.
4.Same logic for the third workflow.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / chiranjeevi
We can handle through unix scripts(Job). Using pmcmd
command you can find the status of the first workflow .IF
First wf failed then you can run the second workflow using
pmcmd command.The same thing applicable for 3 wf also.
Please correct me if i am wrong.
Thanks
Chiranjeevi K
| Is This Answer Correct ? | 2 Yes | 0 No |
two ways to do this 1: Use worklet for each workflow and
create and workflow with these worklets and create
dependency. 2: Use a scheduling tools such as control M or
Autosys JIL to create dependency among workflows.
| Is This Answer Correct ? | 2 Yes | 3 No |
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
How can we use mapping variables in informatica? Where do we use them?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain grouped cross tab?
Separate from a database, an information bazaar, and an information stockroom?
Enlist the advantages of informatica.
What is native users?
What are the tasks that source qualifier performs?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
Teradata 
