Answer Posted / 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.

What is the difference between writing a joiner query in ANSI style and THETA style?

2320

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1006

---

How to Create a folder using pmrep command?

1104

---

Write the program through which the records can be updated?

935

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2179

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2209

---

Explain why we use partitioning the session in informatica?

1006

---

Differentiate between joiner and lookup transformation?

1048

---

In warehouses how many schemas are there?

1010

---

What is lookup transformation?

1002

---

Can we create two repositories on same database instance in oracle?

1014

---

What are mapplets?

1211

---

What are the static cache and dynamic cache in informatica?

1139

---

What is meant by incremental aggregation?

1021

---