Answer / james

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.

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.

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

Answer / dharmendra singh

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.

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

State the differences between sql override and lookup override?

0 Answers  

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---