Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5863 Views
- CTS, I also Faced
- E-Mail Answers
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 the flat file partition and where have to specify it
Explain how many types of dimensions are available in informatica?
design of staging area?
What are the types of data that passes between informatica server and stored procedure?
what are presession,postsession success and postsession failure commands ?
What is the advantage of persistent cache? When it should be used.
How do you implement unconn. Stored proc. In a mapping?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
What is rank transformation?
Teradata 
