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

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


Can we run session without using workflows?

5 Answers   TCS,


What are the tasks that can be performed using sq?

0 Answers  


How to run a session, which contains mapplet?

1 Answers  


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,


can anyone suggest best free Talend data integration training online

0 Answers  


How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,


if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  


in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


Categories