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 |
write a query to retrieve the latest records from the table sorted by version(scd)
What are two types of processes that informatica runs the session?
can any one explain me about junk dimension
I have a flat file, want to reverse the contents of the flat file
What is the Rank index port in Rank transformation?
how to identify new and old values in source qualifier or any other transformations using informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the new features of the server manager in the informatica 5.0?
How can you define a transformation? What are different types of transformations in Informatica?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
How do you implement scheduling in Informatica?