Interested to Buy Any Domain ? << Click Here >> for more details...
What is the approximate size of data warehouse?
- 6 Answers
- 38387 Views
- Accenture, i3 Solutions, I also Faced
- E-Mail Answers
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 |
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
How to fix the etl bugs..Tell me the process?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
how we can update a target table without update strategy and update override?
How does the aggregator transformation handle null values?
what is junk dimension
How to call shell scripts from informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
When the informatica server marks that a batch is failed?
How to generate sequence numbers without using the sequence generator transformation?
how i will stop my workflow after 10 errors
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
Teradata 
