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
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is flashback table ? Advance thanks
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can we get 1st record through Informatica(without sequence number).
Plz can any one say me how to get the informatica certification materials and dumps
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are Dimensional table?
What are the restrictions of union transformation?
Which is the t/r that builts only single cache memory?
Explain the aggregator transformation?
what is INFORMATICA TESTING process
list out all the transformations which use cache?
Enlist few areas or real-time situations where informatica is required.
draw informatica architecture 8.6 ?