What is the approximate size of data warehouse?

Answer Posted / sudheer

maximum size of conventional databases(legacy systens) can
be specified as 512PB(Peta Byte=(10^15)).
but,maximum size of a data ware house cannot be specified.
it depends on the memory of number of systems connected to
the server!!
we can expect that the maximum size will be definitely
thrice the max size of DB i.e., 512pb.

so, max size of a data ware house will be >= (3*512=1536pb)

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10282


What is informatica powercenter repository?

716


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2299


What is meant by active and passive transformation?

587


What are the types of schemas we have in data warehouse.

534






How many numbers of sessions can one group in batches?

625


what is Active lock explain

2374


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1771


How to delete duplicate row using informatica?

613


What are the differences between oltp and olap?

553


What happens when a session fails and you click on recover?

660


What is meant by a domain?

632


Under what condition selecting sorted input in aggregator may fail the session?

667


In warehouses how many schemas are there?

585


Why do we need informatica?

554