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 / 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 |
Post New Answer View All Answers
How do you load unique records into one target table and duplicate records into a different target table?
What are the differences between source qualifier and joiner transformation?
In warehouses how many schemas are there?
Why union transformation is an active transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Why update strategy and union transformations are active? Explain with examples.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you migrate data from one environment to another?
How will the document be delivered to me?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the function of look up transformation?
What are the main issues while working with flat files as source and as targets ?
What are active and passive transformations?
Separate from a database, an information bazaar, and an information stockroom?
What are the designer tools for creating transformations?