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
- 19927 Views
- Accenture, I also Faced
- E-Mail Answers
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
What is meant by query override?
What is a sorter transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What happens when a session fails and you click on recover?
server hot-ws270 is connect to Repository B. What does it mean?
What are the various types of transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the static cache and dynamic cache in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How might you approve all mappings in the archive all the while?
Explain the scenario which compels informatica server to reject files?
How to create Target definition for flat files?
Explain how many types of dimensions are available in informatica?
What is the need for an etl tool?
