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

If informatica has its scheduler why using third party scheduler?

1269


what is the hint? how to use it to reduce the query processing in program?

7841


Why union transformation is an active transformation?

1049


What is informatica metadata and where is it stored?

993


wat are deployement groups in informatica, how it will be used for developers

1720


Define filter transformation?

1103


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1635


How do you take back up of repository?

1162


Performance tuning( what you did in performance tuning)

1990


What are the advantages of informatica?

1014


How many transformations can be used in mapplets.

1937


explain one complex mapping with logic? sales project?

6677


Write the program through which the records can be updated?

1007


What is aggregate cache in aggregator transformation?

1148


How to extract the informatica rejected data?

1223