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

How many number of sessions can one group in batches?

694


What are the advantages of using informatica as an etl tool over teradata?

567


Parameter and variable differences

1615


Why filter transformation is an active one?

565


What is target load order?

805






Why update strategy and union transformations are active? Explain with examples.

714


How union transformation is used?

593


How can you generate reports in informatica?

581


What is the fact table?

589


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

561


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

632


Enlist the tasks for which source qualifier transformation is used.

588


How to configure mapping in informatica?

674


What are the different lookup cache(s)?

620


What is mapping debugger?

572