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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is difference between stored procedure transformation
and external procedure transformation?

Question Posted / swetha

Answer Posted / swetha

In case of storedprocedure transformation procedure will be
compiled and executed in a relational data source.yoU need
data base connection to import the stored procedure in to
your maping.Where as in external procedure transformation
procedure or function will be executed out side of data
source.Ie you need to make it as a DLL to access in your
maping.No need to have data base connection in case of
external procedure transformation.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1936

What are the differences between joiner transformation and source qualifier transformation?

1109

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2036

What is data movement mode in Informatica and difference between them?

1076

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1063

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1021

What are the limitations of joiner transformation?

1055

What are mapplets? How is it different from a Reusable Transformation?

1041

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7285

Explain where to store informatica rejected data? How to extract the informatica rejected data?

964

Which are the different editions of informatica powercenter that are available?

988

What is update strategy transform?

1037

What is sequence generator transformation in informatica?

1006

my source is junk data how will u remove that junk data by using unix please any one replay me

3660

can anyone suggest best free Talend data integration training online

1638