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
How can a transformation be made reusable?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
which one is better performance wise joiner or look up
How to improve the performance of a session using sorter transformation?
How do you handle two sessions in Informatica
How to differentiate between the active and passive transformations?
What is expression transformation?
How to join three sources using joiner? Explain though mapping flow.
Which version configuration tool used in ur project?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain about cumulative Sum or moving sum?
Explain about Informatica server process that how it works relates to mapping variables?
Explain load alternative records / rows into multiple targets - informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the scenario which compels informatica server to reject files?