What is the approximate size of data warehouse?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update a particular record in target with out running whole workflow?

1154


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3444


can anyone suggest best free Talend data integration training online

1256


What are connected or unconnected transformations?

627


Can we override a native sql query within informatica?

626






what is degenerated dimension?

3150


What do you mean by channel change?

537


What is the use of transformation?

570


How can you validate all mappings in the repository simultaneously?

753


What is the difference between source qualifier transformations source filter to filter transformation?

576


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6371


What are the different types of olap? Give an example?

555


During the running session, output files are created by informatica server. Enlist few of them.

538


Why filter transformation is an active one?

562


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4309