-
Transmission Media
What do you mean by Transmission Media? Describe various types of Transmission Media.
shreya890
- Feb 15th, 2011
I think transmission media is the media from which you enable the datawarehouse to be accesed via web. I am not sure about different tramission media's
-
What is Dimensional Modelling
rajnsuccess
- Jan 10th, 2011
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimen...
kevin0209
- Aug 30th, 2010
Dimension modelling is a logical design technique that seeks to present the data in a standard framework that allows users for high performance accesss.
-
I want to know how to protect my data over networ.which software will be use
udgar213
- Apr 13th, 2011
To protect data over the server the ..we can use the data encryption technique,the file to be transmitted can be encrypted and send. we can use the protocols like NDM and SFTP to transmit the data.
-
What is Normalization, First Normal Form, Second Normal Form , Third Normal Form
Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 1N.F:- The table should caontain scalar or atomic values. 2 N.F:- Table should be in 1N.F + No partial functional dependencies 3 N.F :-Table should be in 2 N.F + No transitive dependencies
dstorkey
- Mar 24th, 2009
To paraphrase the oath, and help you remember, in 3rd normal form data in the table depends on the key, the whole key, and nothing but the key.
Jyothsna Tallapally
- May 10th, 2006
Normalization:It is the process of efficiently organizing data in a database.There are 2-goals of the normalization process: 1. Eliminate redundant data 2. Ensure data dependencies make sens...
-
What is Fact table
Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.
munavar.shaik
- Jan 20th, 2011
A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts tableA dimension table is the entity describing th...
ashwinijawalgekar
- Jun 9th, 2010
Fact table is a normalized table divided in to 2 parts Link to all dimension tables -> First part of fact table contains set of foreign keys which links to the respective dimension t...
-
What is a dimension table
Answer posted by Riaz Ahmad on 2005-06-09 14:45:26: A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes.
Read Best Answer
Editorial / Best Answer
Answered by: Edmond
- Apr 13th, 2007
Let's be very clear. this is a very simple, and becomes a very confusing subject.
A fact table is an entity representing the numerical measurements of the business. A dimension table is the entity describing the textual representation of the business.
In a banking model, the account and balances are the measurements within the fact table, where customer name, social security, address, time period of the account, are the dimensions (customer/time).
Hope this answers the clarification.Anindya1281
- Jun 5th, 2011
In very simple termsFact : this contains all numeric attributesDimesion : this contains all non numeric , textual attributesIn order to rememberFact : Any answer to What user want to see is factfor ex...
mickey_gupta
- Mar 4th, 2009
Dimension table contains reference data which gives meaning to fact data. You can also view them as parameters across which you want to analyze the fact data.
-
How do you join the data from multiple Data Marts ? if so what would be the criteria?
Anindya1281
- Jun 5th, 2011
HiOne way of connecting data from multiple datamarts is with the use of confirmed dimensionsConfirmed dimensions are dimensions which are shared between multiple fact tables within a datamart or betwe...
-
What are late arriving Facts and late arriving dim ? How does it impacts DW?
Sukanya Das
- Jun 4th, 2011
Late arriving Fact table:For example there was a credit card of transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2007. During this period there is a possibility of change...
Are Ramakrishna Rao
- Aug 14th, 2007
Late arriving Fact table:??????? This is rarely happens in practice. For example there was a credit card of HDFC transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2...
-
What is the role of surrogate keys in data warehouse and how will u generate them?
Anindya1281
- Jun 5th, 2011
surrogate key is a substituted key for the business key in data warehouseThis is generated while the loading process (ETL)attributes of surrogate key1) It has the same granularity of the Business Key ...
bcsandip
- Oct 8th, 2010
Along with Jeff's answer, the surragate key also distinguish 2 records with the same combined primary key in the denormalized DWH tables where history is maintained.
-
What is difference between logical design module and physical design module ?
RathiRam
- Aug 24th, 2011
A logical design is conceptual and abstract. You do not deal with the physical implementation details yet. You deal only with defining the types of information that you need. Your logical design shoul...
-
What are the steps to build the data warehouse?
Read Best Answer
Editorial / Best Answer
ankeshjain- Member Since Aug-2008 | Aug 17th, 2008
1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
Ravi Teja N
- Sep 16th, 2011
The steps used to develop a DWH are 1. Gathers Operational Source System 2. Data Staging Area 3. Data presentation Area 4. Data Access Tool Lets have a detailed information about each stage: Operat...
mohanbabu
- Aug 20th, 2011
We can create the dwh in two ways i.e
1. top down approach
2.bottom up approach -
What types of datasources are in informatica
what are homegeneous sorces and heterogeneous data sources ? Is flat file different from those two
-
-
-
Describe how you would establish the operational (service) requirements for the data warehouse?
Hello Guys....please help...
I have an interview with NHS for a data ware house role and for which they have asked me to prepare a presentation on a topic "Describe how you would establish the operational (service) requirements for the data warehouse? I have 10 minutes for the presentation"
But I am a little confused with what i should put in the presentation. Please can anyone... -
-
Do u need seperate space for Datawarehouse & Data mart
moluguri
- Aug 30th, 2012
I think, we don't need separate space for Data Warehouse and Data Mart. Data Warehouse is a collection of Data Marts. Data Mart is a particular line of business..
Gvkishore
- Jan 16th, 2012
Why so.....Is there any advantage creating the DWH after creating the Datamarts...?
what is the use of Vice versa...? -
-
-
Data Warehousing Basics
Read Best Answer
Ans