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 |
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How can u work with remote database in informatica?did you work directly by using remote connections?
What is the default join that source qualifier provides?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
What is Datadriven?
what is the size of ur database(like oracle)
Could any one to tell Fact table Partitioning?
what is the predefined port in dynamic lookup
what is a transforamation?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?