Question { Wipro, 11940 }

Define informatica repository?

Answer

Repository is Brain of Informatica.
In every project must and should to use one or more repository.
It is metadata object

Question { CTS, 64182 }

Query to get max and second max in oracle in one query ?

Answer

Select Sal From Emp A
WHERE 1=(Select Count(Sal) From Emp B
WHERE B.Sal>A.sal)
GROUP By Sal Desc

Question { CTS, 5829 }

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

Software tools for Datawarehouse
----------------------------------
1)Operating system (any)
2)Database(Oracle, MySQL server,teradata,DB2 etc.)
3)ETL(Informatica/Abinitio/Datastage/MSBI etc.)
4)Reporting(Business Objects/Cognos/MSBI etc.)