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 touse stored procedure in ETL Application?

Answer Posted / susheel sharma

in our project we used store procedure to implement CDC
(change data capture) for incremental data load.

generaly store procedure used when you have to implement
your complex business logic.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1081


What is domain in terms of informatica?

1001


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1115


Which transformation is needed while using the Cobol sources as source definitions?

1167


have u done any performance tuning? how u ll do?

2294


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2316


Tell me about MD5 functions in informatica

927


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

993


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

1031


What is event and what are the tasks related to it?

1118


How to extract sap data using informatica? What is abap? What are idocs?

1176


What do you mean by channel change?

1039


Enlist the advantages of informatica.

1063


 Informatica Checkpoints

3325


Is there any way to read the ms excel datas directly into informatica?

1021