-
-
-
Increase row level limit of Cognos Query Reports
How can we increase the row level limit of cognos query reports?This deals with the administrative part of impromptu.
-
Developing and Designing
Does the ETL developer involve in physical database design and logical database design. Are these developer duties?
-
Clustering and Classification algorithms
How to implement clustering and classification algorithms in data mining
-
OLAP and OLTP
What is the difference between OLAP and OLTP?
Pardeep Kaur
- Jan 31st, 2008
OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be integrated.We can create reports that are m...
-
Can we partition the Universe? If yes then How?
-
Value prompt disadvantages
What are the disadvantages of value prompt?
-
Aggregate awarness
What is Aggregate awarness?
-
Multidimensional data models
Explain multidimensional data models and how they are integrated with the architecture you have already designed
-
How many fact tables we can use in one project?
chskumar
- Dec 24th, 2007
We can use 'N' number of fact tables in a Project.but,it depends as per our requirements or cleint specifications.......so, be sure that what r the cleint specifications..........its all as per my knowledge...........
balaji
- Nov 27th, 2007
N number of fact tables we can use,
-
How many clustered indexes can u create for a table in DWH?In case of truncate and delete commanda what happens to table which has unique id.
ecoverdale
- Dec 4th, 2007
In SQL Server terms:Only one clustered index is permitted on a table.When a delete statement is performed it is a logged transaction which can be rolled back.? The delete does nothing to the identity...
Hakoonamatata
- Jul 9th, 2007
By definition, a clustered index physically arranges all data in a table in a sequential manner. Since you can not have more than one physical arrangements of data in a table, you can have just ...
-
Which of the following technology gives highest near real time ETL performance?Informatica RTAb Initio CFDatastage CDCSocket Programs
ravi_kumar_garre
- Nov 13th, 2007
I heard that Ab Initio is faster then Informatica hence DataStage as well.Regards,Ravi Kumar Garre
-
What is the difference between dependent data warehouse and independent data warehouse?
ravi_kumar_garre
- Nov 13th, 2007
Hi I believe that Dependent Dataware house are build on ODS. And Independent Dataware houses are real-time dataware having no dependency on any ODS systems. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in
ravi_kumar_garre
- Nov 12th, 2007
There is a third type of Datamart called Hybrid. The Hybrid datamart having source data from Operational systems or external files and central Datawarehouse as well. I will definitely check for D...
-
-
The DW process model is the result of designing refresh processing and consists of specifications for all the following EXCEPTMapping of source data to target dataMeasuring to meet monitoring requirementsInformation deliveryInterpreting and encrypting of metadata
-
Data mining cannot be doneIn databaseIn file systemAt real-timeIn reporting tool
ravi_kumar_garre
- Nov 12th, 2007
As i believe its At Real-TimeRegards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in
-
-
Give an example for multidimentional technique?
ravi_kumar_garre
- Nov 11th, 2007
Generation of CUBES is also a multiDimensional technique. You can reply if you are looking for more details.Regards,Ravi Kumar Garre
herbert
- Dec 9th, 2006
Eg:slice and dice
-
I have two Universes created by two difference database can we join them in Designer & Report level? How
ravi_kumar_garre
- Nov 11th, 2007
We can link one universe to other universe in Universe parameters.Regards,Ravi Kumar Garre
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans