What are the hard ware required for a normal sized data warehouse? and
What are the software required for a normal kind of data warehouse?
Answers were Sorted based on User's Feedback
Answer / itsranjan
Software tools for Datawarehouse:
1)Operating system(Unix or windows)
2)Database(Oracle,DB2 etc.)
3)ETL(Informatica/Abinitio/Datastage/MSBI etc.)
4)Reporting(Business Objects/Cognos/MSBI etc.)
5)Datamodelling(Erwin/Visio etc.)
These are some common softwares i have mentioned.But some
other softwares are also present.
Is This Answer Correct ? | 4 Yes | 0 No |
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
what are presession,postsession success and postsession failure commands ?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
To import the flat file definition into the designer where should the flat file be placed?
What is update override?
can v update d records in target using update stargey without generationg primary key ? explain
What are the different types of schemas?
what is degenerated dimension?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
how will compare two mappings in two different repository?
How to read data from flat file source if the data is in paragraph format?