-
-
What types of datasources are in informatica
what are homegeneous sorces and heterogeneous data sources ? Is flat file different from those two
-
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 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...
-
Quality center 10.0 version(save method is not working), while uploading attachments to quality center
The code below ,is for uploading attachments to quality center 10.00
Function UpLoadAttachmentToQC(FilePath)
Set ObjCurrentTest = QCUtil.CurrentTest.Attachments
Set ObjAttch = ObjCurrentTest.AddItem(Null)
ObjAttch.FileName = FilePath
ObjAttch.Type = 1
ObjAttch.Post
ObjAttch.Refresh
End Function
FilePath=”C:abc.vbs” -
Data Planning & Modeling
What are the major differences between the two approaches to data planning and modeling – enterprise modeling and view integration? Why do these two methodologies usually yield different results? In what ways does the existence of pre-packaged data models affect these approaches?
-
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 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...
-
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 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.
-
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 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...
-
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 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.
-
Data Validation Strategies for Data Mart
What are Data Validation Strategies for Data Mart?
-
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
-
Final Component of Dimensional Model
As a final component of the dimensional model, the architect can do all of the following EXCEPTA) identify entity relationships.B) add relevant dimensional attributesC) identify derived measuresD) identify derived facts
charlie2k
- Nov 27th, 2010
Identify the relationship is one of the first things to do. It is used for preparing the conceptual data model.The preparation of conceptual data model --> logical data model --> physical data model.
-
High Speed Power Application
Which one of the following is used for high speed power application? a) BJT b) MOSFET c) IGBT d) TRIAC
-
Non-Additive Facts
Give an example of non-additive facts?
rummyraj
- Oct 13th, 2010
Here is an actual example from my current project.We sell Parts globally. Each part is being sold at different price in different regions. Each part has different cost to the company in different regi...
-
Explain ODS and ODS types.
chand.abinitio
- Sep 27th, 2010
ODS is defined as subject-oriented and integrated data and volatile
repository of data.
Contains current or near to current data
could be used for day to day reporting/ low-level analysis
updatable data store
contains detail data, no summarization
data in homogeneous form.
jaggu_mandya
- Jan 11th, 2008
It is designed to support Operational Monitoring. It is subject oriented,integrated database which holds the current,detailed data.data here is volatile
Data Warehousing Basics
Read Best Answer
Ans