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

What is target designer and target load order?

1103


What is the different lookup cache(s)?

1086


Write the prerequisite tasks to achieve the session partition?

1156


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003


what is the size of your data warehousing?

2093


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1765


Enlist few areas or real-time situations where informatica is required.

1080


define galaxy repository in informatica

2225


What is olap (on-line analytical processing?

1067


What is an expression transformation in informatica?

1036


Write the advantages of partitioning a session?

1278


How do you remove duplicate records in informatica? And how many ways are there to do it?

1165


Explain pushdown optimization $pushdownconfig parameter - informatica

1135


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237