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

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

What is the function of union transformation?

0 Answers  

rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

0 Answers  

what is degenerated dimension table with scenario

2 Answers   HCL,

Clarify the aggregator change?

0 Answers  

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

what are challenges that you faced in testing? give solution to it?

1 Answers  

What is meant by incremental aggregation?

0 Answers  

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

What is joiner change?

0 Answers