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...

What is the need of building a data warehouse?

Answer Posted / vas.chiky

Having separate OLAP DWH database for analysis, increases
the performance of reports.

even during backup or crash period of oltp, OLAP database
will not get affected.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1082


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251


Performance tuning in UNIX for informatica mappings?

2568


Define filter transformation?

1098


What is a joiner transformation and why it is an active one?

1082


is it possible to index the data in cache of lkp transformation ?

2029


How does a sorter cache works?

1071


What is a passive transformation?

1105


Explain the features of connected and unconnected lookup.

935


Explain the etl program with few examples.

1050


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1130


Can we create a Integration service without a Repository service and vice versa?

1215


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953


What are the different transaction levels available in transaction control transformation?

1209