Answer Posted / jayeshmumbai

I would use following methods

1. Create a KSH to call (pmcmd startworkflow) two workflows
one after another (or two statements in ksh). And if
required, I can check successful run of previous workflow
before running another.
2. Make use of command object in second workflow. This
object will be based on ksh which can wait on file created
by successful run of first workflow
3. Make use of even wait task as file watcher and watch a
file created by first workflow.
4. Crude way: Determine workflow execution time. Schedule
two workflows by considering execution time difference.

How you can differentiate between connected lookup and unconnected lookup?

1105

---

What is fact table? Explain the different kinds of facts.

1125

---

How to do unit testing in informatica? How to load data in informatica ?

1185

---

COM components can be used in Informatica

2454

---

What is informatica etl tool?

1060

---

How you prepared reports for OLAP?

1658

---

What is dimensional table? Explain the different dimensions.

1253

---

What is informatica metadata and where is it stored?

1043

---

explain about unit testing? in real time?

2265

---

What is flashback table ? Advance thanks

1998

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1963

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1908

---

How to handle decimal places while importing a flatfile into informatica?

1241

---

Explain the aggregator transformation?

1222

---

r u done any partitions in ur project?

1863

---