Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2300


What do you mean by blocking transformation?

1033


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2300


How to do the error handling of if ur source is flatfiles?

1962


What are the popular informatica products?

1008


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1130


What is event and what are the tasks related to it?

1118


What is repository manager?

984


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2022


Explain the shared cache and re-cache?

1109


How to load data in informatica ?

999


What does command task mean?

1136


Global and Local shortcuts. Advantages.

2032


Why update strategy and union transformations are active? Explain with examples.

1235


design of staging area?

2026