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.
Answer Posted / 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 |
Post New Answer View All Answers
What is the fact table?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is incremental aggregation?
what are the Methods For Creating Reusable Transformations?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are different types of transformations available in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the tasks that source qualifier perform?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is Session and Batches?
Global and Local shortcuts. Advantages.
EXL informatica Questions
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??