Data Warehousing Community Forum
February 08, 2012, 11:35:27 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Calling a Procedure in Informatica ?  (Read 3259 times)
rkdhn
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 3


View Profile
« on: November 07, 2007, 01:51:43 pm »
In Informatica, an Oracle Procedure/Package can be executed through -

  • Stored Procedure Transformation.
  • Calling a Procedure/Package through Post-session command.

Can anyone explain the difference in between these two.

When they will be taken into consideration...!

Thanks
rkdhn
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: November 13, 2007, 09:41:47 am »

Difference in between calling a Procedure through Post-Session Command and Stored Procedure Transformation is as follows -

  • Usage of a Stored Procedure transformation in the mapping is nothing but exection of the procedure in the data flow, where as Post-session command calls it as separation.

  • The Stored Procedure Transformation executes the Package/Procedure for each and every record, where as the Post-session command task executes for the whole at one time.
« Last Edit: November 13, 2007, 09:44:01 am by Sipra » Logged
Sipra
Founder

www.dwforum.net
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: