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
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the different lookup cache(s)?
What is dynamic cache?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
When do you use sql override in a lookup 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?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is rank transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is expression transformation?
On which transformations you created partitions in your project?
What is informatica etl tool?
What is the function of aggregator transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the difference between informatica 7.0 and 8.0?