Answer / pravin

the minimum size of data warehouse is 100Giga byte
and maximum size is in n tera bytes(n=any integer)

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!!

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)

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 ?

Answer / jeevankumar medapati

smal projects:::100gb to 500 gb
medium projects:: 500gb to 1000 gb
large projects :::1000 gb to 1200gb etc

Answer / vasanth

it could range somewhere between 25-40 terabytes

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

What is a snowflake schema?

0 Answers  

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

what is $$$$?

0 Answers   TCS,

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,