Interested to Buy Any Domain ? << Click Here >> for more details...
How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
- 1 Answers
- 19923 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What is DR strategy for Informatica project?
create a mapping to retrieve the employees who are getting salary greater than average salary?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
What is sorter transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What is dynamic cache?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how will you remove the duplicate records from flat file without using sorter?
what is runtime variable?
Can we insert ,update ,delete in target tables with one update strategy tran.?
Teradata 
