Interested to Buy Any Domain ? << Click Here >> for more details...
I want to run a informatica worklow after complition of
oracle procedure. That procedure is not running through
informatica and can be run at any time in database.
Informatica is in windows environment. Is it possible ? If
yes please explain.
- 3 Answers
- 8129 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
How to handle changing source file counts in a mapping?
what is the size of your data warehousing?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
Explain sessions and how many types of sessions are there?
HOW TO GET THE LATEST DATA IN SCD ?
What are conformed dimensions?
What is the use of transformation?
How to use procedural logic inside infromatica?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
What is the Router transformation?
Explain in detail about scd type 1 through mapping.
what is materialized view?
Teradata 
