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 does role playing dimension mean?

1044


What is mapping debugger?

1017


what is the -ve test case in your project.

2407


What is a dimensional model?

982


What happens when a session fails and you click on recover?

1120


can you please explain me pre session and post session options?

7570


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

1078


How to elaborate tracing level?

1179


How to configure mapping in informatica?

1173


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1082


I have a flat file, want to reverse the contents of the flat file

1128


What is a difference between complete, stop and abort?

1083


What does “tail –f” command do and what is its use as an Informatica admin.

1107


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100