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 / grhyrngnn yjhyj

i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

draw informatica architecture 8.6 ?

3871


Differentiate between sessions and batches?

1016


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1123


Define mapping and session?

1033


How to create or import flat file definition in to the warehouse designer?

1067


Explain the types of lookup transformation?

1043


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

1080


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1038


What is rank transformation?

989


On which transformations you created partitions in your project?

1347


what is mean by complex business rule ?

2158


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199


How you can differentiate between connected lookup and unconnected lookup?

1060


What are the types of data warehouses?

1525


Scheduling properties,whats the default (sequential)

1952