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

why we use stored procedure transformation?

Answer Posted / vas.chiky

for complex results, which we cannot obtain in SQL or from
informatica transformation, we go for procedures.

Also doing the calculation in database level doesnt makes
work load high for our informatica server.

process will be given to database.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

985


How you know when to use a static cache and dynamic cache in lookup transformation?

1792


How to delete duplicate row using informatica?

982


What are the limitations of joiner transformation?

1044


Explain the different dimensions.

913


In warehouses how many schemas are there?

1010


Explain dynamic target flat file name generation in informatica

1008


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

1057


How to open an older version of an object in the workspace?

1127


What is flashback table ? Advance thanks

1872


How are the sources and targets definitions imported in informatica designer?

1050


Is it possible to use a client with different version than that of its Informatica server?

1075


What is mapping debugger?

944


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1072


What are the different ways to implement parallel processing in informatica?

1340