How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer Posted / kalyan
If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
what is the hint? how to use it to reduce the query processing in program?
Why union transformation is an active transformation?
What is informatica metadata and where is it stored?
wat are deployement groups in informatica, how it will be used for developers
Define filter transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How do you take back up of repository?
Performance tuning( what you did in performance tuning)
What are the advantages of informatica?
How many transformations can be used in mapplets.
explain one complex mapping with logic? sales project?
Write the program through which the records can be updated?
What is aggregate cache in aggregator transformation?
How to extract the informatica rejected data?