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

How do you convert single row from source into three rows into target?

1208


What is a pre-defined event and user-defined event?

1078


What is fact table? Explain the different kinds of facts.

1121


How can you increase the performance in joiner transformation?

1246


What are the reusable transformations?

1214


What is a surrogate key?

1150


How to do unit testing in informatica? How to load data in informatica ?

1179


how many types of dimensions are available in informatica?

1173


What is olap (on-line analytical processing?

1107


tell me 5 session failure in real time how can you solve that in your project?

2387


Where are the source flat files kept before running the session?

1137


How to generate or load values in to the target table based on a column value using informatica etl tool.

1110


What are the measure objects?

1251


Where can we find the throughput option in informatica?

1104


Briefly define reusable transformation?

1178