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

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1913


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1446


How to go to the older version for a mapping?

600


Define update strategy?

634


While importing the relational source definition from the database, what are the metadata of source that will be imported?

785






What are the advantages of informatica?

571


What is the use of target designer?

603


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.

2293


What is joiner transformation?

584


Write the advantages of partitioning a session?

742


What are the conditions needed to improve the performance of informatica aggregator transformation?

578


What is a code page?

711


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

1751


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1472


What is dynamic cache?

610