How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer / 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 |
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What are the different options used to configure the sequential batches?
Can you use one mapping to populate two tables in different schemas
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How many number of sessions that u can create in a batch?
Kimball and Inmon methodologies?
What happens when a session fails and you click on recover?
how to import multiple flat files in to single target where there is no common column in the flat files
Router T/R is active but some people are saying it is also passive which is exactly right?
How can i send first half of the records to one target and Remaining to other target?
What is exclusive and normal mode for repository services?