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

Define filter transformation?

1147


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153


What is standalone command task?

1374


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2199


What are the designer tools for creating transformations?

1158


How to partition the Session?

1151


Differentiate between sessions and batches?

1069


Mention a few design and development best practices for informatica?

1045


Explain sessions?

1140


How can informatica be used for an organization?

1274


explain about unit testing? in real time?

2265


How identifying bottlenecks in various components of informatica and resolving them?

1178


Differentiate between Load Manager and DTM?

2214


What is joiner transformation?

1067


How can we remove the duplicates from flat file source?

1075