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
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??
Name the different lookup cache(s)?
How to elaborate powercenter integration service?
Enterprise data warehouse your projects phase by phase explain?
What is rank transformation?
What are the different types of olap? Give an example?
Parameter and variable differences
What is incremental aggregation?
Write the advantages of partitioning a session?
What is a transaction control transformation?
what is $$$$?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to do the error handling of if ur source is flatfiles?
What are multi-group transformations?
Explain in detail scd type 2 through mapping.