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
- 7534 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 |
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
can we override a native sql query within informatica? Where do we do it?
can we generate reports in informatica ? How?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
in oracle write query yourname+1 from dual
What all join we can perform in LOOKUP transformation?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
what happens if you try to create a shortcut to a non- shared folder?
What are Dimensions and various types of Dimensions?
Teradata 
