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
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is Data Caches size?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the main features of Oracle 8i with context to datawarehouse?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the scenario which compels informatica server to reject files?
What is the session task and command task?
How we can create indexes after completing the load process?
How do you handle two sessions in Informatica
What are the databases that informatica can connect to windows?
What is dynamic cache?
What is an expression transformation in informatica?
Explain scd type 3 through mapping.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is transformation?