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

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

830


Differentiate between a repository server and a powerhouse?

755


Plz can any one say me how to get the informatica certification materials and dumps

1773


Explain in detail about scd type 1 through mapping.

796


what is size of u r database?

2012






Did u used latest transformations of 8.6.0? for what?

1621


Why is sorter an active transformation?

849


In warehouses how many schemas are there?

751


How many dimensions are there in informatica?

795


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

806


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

724


explain one complex mapping with logic? sales project?

6372


How do you convert single row from source into three rows into target?

843


Explain about Informatica server process that how it works relates to mapping variables?

797


Write the unconnected lookup syntax?

813