Answer / deva

This can be possible with unix . Create a shell scripts
which first has to Execute the stored procedure or Package
and we have command to check the completion or procedure
after that use Pmcmd command in the same unix to start the
workflow.

Answer / amarnath

in the pre-session of the target at session level just give
a command like call procedure_name. this will first execute
the stored proc and then the workflow will load the data.

Answer / asha

Oracle proc can create a 0 byte file at the end of the proc
and infa workflow can wait for the file (indicator file) to
begin the execution.

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

What are the different components of powercenter?

0 Answers  

---

How we can create indexes after completing the loan process?

0 Answers  

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---

Define the various join types of joiner transformation?

0 Answers  

---

What is polling?

1 Answers  

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---