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 |
What is meant by target load plan?
explain abt joiner t/r?
What is Collect performance data in informatica and what is the use of it.
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
what is the difference between lookupoveride and joiner?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
If we set dd_insert in mapping and Delete in session properties what will happen.?
if i have a delimited file as source so how can we seperate this file into three diff targets?
What are session parameters ? How do you set them?
what is lookup ?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Why use the lookup transformation ?