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?
Answer Posted / 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 |
Post New Answer View All Answers
server hot-ws270 is connect to Repository B. What does it mean?
can we override a native sql query within informatica? How do we do it?
Differences between connected and unconnected lookup?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Performance tuning in UNIX for informatica mappings?
Define pmcmd command?
Explain the difference between a data warehouse and a data mart?
Difference between Data and Index Caches?
Which is the t/r that builts only single cache memory?
What are the static cache and dynamic cache in informatica?
Differentiate between sessions and batches?
how many types of dimensions are available in informatica?
How does a sorter cache works?
What does cheating measurement mean?
What is the way to execute pl/sql script using informatica mapping?