What is the advantages of converting stored procedures into Informatica mappings?

  • Interview Candidate
  • 6
  • 4133

Showing Answers 1 - 6 of 6 Answers

Gayathri84

  • Jan 18th, 2007
 

Stored Procedures are Hard to maintain and Debug . Maintaince is simpler in Informatica. Its a User friendly tool.

Given the Logic. Its eaier to create a Mapping in Informatica than write a Stored Procedure.

Thanks,

Gayathri

  Was this answer useful?  Yes

toffycoffy

  • Feb 27th, 2007
 

a stored procedure call is made thru an ODBC connection over a network (sometimes the info server resides on the same box as the db)...since there is an overhead in making the call, it is inherently slower.  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions