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?



How to call stored Procedure from Workflow monitor in Informatica 7.1 version?..

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

Post New Answer

More Informatica Interview Questions

What is meant by target load plan?

0 Answers  


explain abt joiner t/r?

1 Answers   IBM,


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,


what is the difference between lookupoveride and joiner?

3 Answers  


tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,


If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


What are session parameters ? How do you set them?

0 Answers  


what is lookup ?

7 Answers  


In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  


Why use the lookup transformation ?

2 Answers   Informatica,


Categories