What is the approximate size of data warehouse?
Answers were Sorted based on User's Feedback
Answer / pravin
the minimum size of data warehouse is 100Giga byte
and maximum size is in n tera bytes(n=any integer)
| Is This Answer Correct ? | 18 Yes | 8 No |
Answer / sudheer
hi praneeth
thanx for ur correspondence!! i agree with u dat i was not
more specific about the type of database in my answer. i
try to change it now.. wat i meant is for oracle
database!!! its size is 512pb,as you know!!
well,if u hav any clarifications or if u need any
discussion regarding any concepts related to oracle and
data ware house, u can reach me @8985688521 and @
(sudheerjntu.eee@gmail.com)..
keep in touch!!
regards..
sudheer!!
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / praneeth
Dear Sudheer,
Whatever you said is right. But the size you mentioned is
only for 'ORACLE' database.Different databases have
diferent sizes.
Rest all is fine.
Can u give your mobile number ?
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / jeevankumar medapati
smal projects:::100gb to 500 gb
medium projects:: 500gb to 1000 gb
large projects :::1000 gb to 1200gb etc
| Is This Answer Correct ? | 3 Yes | 6 No |
Answer / vasanth
it could range somewhere between 25-40 terabytes
| Is This Answer Correct ? | 8 Yes | 15 No |
Mention some types of transformation?
What are some examples of informatica etl programs?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
Tell me about informatica architecture.
How do you load unique records into one target table and duplicate records into a different target table?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain scd type 3 through mapping.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what is the difference between informatica6.1 and infomatica7.1
As union transformation gives UNION ALL output, how you will get the UNION output?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
What are the Differences between connected and unconnected lookup?