-
1. What is galaxy schema?2. How many types of hirarechies in datawarehousing concept level?3. How to test report in Business Objects?
ravi_kumar_garre
- Nov 11th, 2007
In Business Objects unvierse creation we do have two types of Hierarchies Custom and Default Hierarchies. Default hierarchies are by default all objects in a given class. For example Time Dimension. By default you can define Time Dimension Year, Quarter, Month and Day.
jahnavi.s
- Sep 20th, 2006
The galaxy schema is also know as fact constellation scheme.it requires no of fact tables to share dimension tables.in dataware housing mainly the people are using theconceptual hierarchy
-
1. How much data hold in one universe?2. What is Core Dimension?
ravi_kumar_garre
- Nov 11th, 2007
Core Dimension is a Dimension table which is used dedicated for single fact table or Datamart. Conform Dimension is a Dimension table which is used across fact tables or Datamarts.
sar
- Apr 21st, 2007
Universe does not hold any data. however practically the universe?is known to have?issues when the objects cross 6000.
-
Can any one explaing about Core Dimension, Balanced Dimension and Dirty Dimesion?
ravi_kumar_garre
- Nov 11th, 2007
I feel that Dirty Dimension is nothing but Junk Dimensions. Core Dimensions are dedicated for a fact table or Datamart. Conformed Dimensions are used across fact tables or Datamarts. Sorry i never heard of Balanced Dimensions.Could some one explain what is Balanced Dimension?Regards,Ravi Kumar Garre
-
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
-
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
-
-
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
-
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
-
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...
-
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
-
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 ...
-
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,
-
Can we partition the Universe? If yes then How?
-
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...
-
1).briefly state different between data ware house & data mart?2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?3).What is meta data?
surajkm99
- Feb 4th, 2008
1) Difference Between Data Warehouse & Data MartIn Simple Terms Data warehouse : is a SUBJECT - ORIENTED, TIME VARIENT, NON-VOLATILE, INTEGRATED Collection of Data, In Support of Management ...
-
How can you implement many to many relation in star schema model?
gopal
- Jan 25th, 2007
HiUpto my knowlege designers implementing this M-M relation asFirst break the schema to 1-M and M-1 relationsLet me correct if any thing is wrong
-
What is critical column?
Anitha
- Feb 23rd, 2007
The columns(granular) that change the values over a perriod of time.
-
Suppose your filtering the rows using a filter transformation only the rows meet the condition pass to the target .Tell me where the rows will go that doesnot meet the condition.Thanks in advance
VVM.SP
- Mar 18th, 2008
In Filter Transformation Those row are not meet to the filter condition they are rejected. These rejected rows are appear in $PMBad.Dir
herbert
- Dec 9th, 2006
Yes there is folder or file in informatica which collects this rejected rows, its location is given while installing the s/w
-
What is the use of data warehousing? Can we perform all the transformations using Oracle?
rmanikandan
- Apr 30th, 2008
Data warehousing is used to perform Historical records & providing all information by client users. Yes we can persom all the transformatioin usring oracle
prudhvi.g
- Sep 3rd, 2007
Datawarehousing is nothing but analysing the data and providing solutions to the business people.Major usage of datawarehousing is that it can analyse the data and stored the data which is historical.
-
Meta Data and Data Dictionary
What are the differences between Meta Data and Data Dictionary?
jryan999
- May 1st, 2008
The “data dictionary” in a database tool (eg. Oracle or Informatica) is simply a repository of metadata. Metadata is however data about the data. The following are examples of m...
pal.amol
- Feb 26th, 2008
HI Metadata is nothing but the data about data , if you take term of informatica in that through metadata only you will be converting or solving the problem. In the flow of Informatica mapp...
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans