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
what is $$$$?
What is transformation?
is it possible to index the data in cache of lkp transformation ?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
In informatica workflow manager, how many repositories can be created?
What are the types of schemas we have in data warehouse.
What are the guidelines to be followed while using union transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is data movement mode in Informatica and difference between them?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is exclusive and normal mode for repository services?
How big was your fact table
What happens when a session fails and you click on recover?
What are the informatica performance improvement tips
How do you promote a non-reusable transformation to reusable transformation?