Answer / priyank

Hi,

We can use,

S1 --> S2 --> DECISION Task --> S3
CMD1 ------->

We will connect S2 and CMD1 to the DECISION Task. In CMD1,
we can give a unix script to check for current day and if
the day is not Saturday, then fail the command task.

In the DECISION task, we will give a condition,

S2.Status=Succeeded and CMD1.Status=Succeeded, then proceed
to S3.

Though I have given this solution, need to check on any
other more efficient method to achieve the given
situation.Will appreciate anyone coming up with a more
efficient solution.

Hope the above solution helps.

Thanks.

Answer / anindita

I would change the link condition from S2 --> s3.
I'll format the Sysdate to return 'DAY' and then check if that is equal to Saturday, if that is true link condition is true else false.

what is index?how it can work in informatica

0 Answers  

---

how many types transformations supported by sortedinput?

4 Answers  

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

---

What is the Difference between DSS & OLTP?

5 Answers  

---

How many number of sessions can one group in batches?

0 Answers  

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

what is incremantal aggregation?

1 Answers  

---

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

---