-
-
Tracing Options available in Data Warehousing
What are the different tracing options available? Can tracing options be set for individual transformations?
joshmohit
- Nov 3rd, 2010
I am not sure if this pertains to the datawarehouse in general but we do have concept of audit dimensions. Also, dimensions with effective dating can help tracing the changes.
sraghav20
- Oct 7th, 2010
I guess, this question should be directed towards particular tools... as a concept, data warehousing would be hard pressed to have any logging...
-
-
Importance of SCD
How is SCD helpful in real time? Give example by taking banking project.
rummyraj
- Oct 13th, 2010
Customer dimension is a good example. Customer address and Phone number frequently changes. So you will update the customer dimension for these changes.Hence its called as SCD. There are several types though. This example is type1 SCD.
-
Dynamic Insert
What is Dynamic Insert?
mkm187
- Oct 5th, 2010
INSERT FIRSTWHEN SAL > 25000 THENINTO special_sal VALUES(DEPTID, SAL)WHEN HIREDATE like ('%00%') THENINTO hiredate_history_00 VALUES(DEPTID,HIREDATE)WHEN HIREDATE like ('%99%') THEN...
-
Rejected Data
How to get rejected data from the join stage without using any stages after join?
-
Fact Table Duplicates
How can we remove duplicates from fact table?
-
Custom Dimensions
What is a custom dimension?
-
What is the main difference between star and snowflake star schema? Which one is better and why?
bcsandip
- May 25th, 2010
Star Schema: 1. Dimension tables directly connected to Fact Table2. Contain de-normalized data3. Data modifications are very easily4. Highest flexibility5. Best performance6. Takes more memory space t...
geetu rani
- Mar 27th, 2008
STAR SCHEMA HAS fact table linked with dimension table directlywhile in snow flake schema the dimension tables can have futher hierarchies between them .it means in snow flake schema the tables are no...
-
AutoSys Jobs Schedule
How can we schedule our jobs in third party tool - AutoSys?
saigarneni
- May 18th, 2010
We need to write shell script to run the job and write JIL on autosys to schedule the job
varghesebinu
- Dec 10th, 2009
Autosys is a total job scheduling solution that allows you to define the event dependencies, time schedules alerts etc making it a complete data center automation tool. An AutoSys job is any single co...
-
Merge Dimension
What is the merge dimension?
Nicolas
- Apr 17th, 2010
Merge dimension is the action in Web Intelligence XI that allows to synchronize two or more data providers through common dimension. Once created, the merged dimension can be used as an object for rep...
-
What is the difference between database and data warehousing?What is the main advantages of data warehousingWhat is mean by data stageWhat is the famous tools used for data warehousing?What is the architecture of data warehouisng model?
brahmiii
- Feb 28th, 2010
Database is the root of any data releted operations where as datawarehousing is a schema or process how effectively we access or utilize a database. Datawarehousing follows the star schema and snowflake schema as its basic schemas and we two other schemas also which are not much important.
sap_23
- Sep 3rd, 2009
Database: A database is used to record, retrieve, update business transactions which are occurred daily in business life. Data ware House: A data warehouse is used to record historical data, purely for analysis purpose for top management.
-
Information Gain Concept
How to remove a particular attribute from table using the information gain concept?
-
Staging and Operational Data Store
What are Staging and Operational Data Stores and what is their difference?
Why does one need staging and why does one need ODS? What will happen if they are not there? Who and how is it decided that a staging or ODS is needed? Which comes first staging or ODS?jryan999
- Feb 3rd, 2010
An Operational Data Store (ODS) is a repository of active "operational" data. It's typically used to hold data for a short period (eg. Days or weeks at most), to help the business ...
srilu1234
- Jan 19th, 2010
Stagining and operational data store are different databases.It can be one database aswell to reduce the cost to maitain two databases.Staging is the place where cleansing is done and Operational Stor...
-
ETL testing
How can we do the ETL testing on Data WareHouse?
anita_09
- Sep 10th, 2009
ETL testing validates that data is transformed correctly from OLTP to data warehouse. Validating the data transformed includes following main verification points: Ensures that all expected...
-
What is data cleaning? How can we do that?
sub_guha
- Jan 25th, 2010
Data cleaning, technically called "Data Cleansing"is a group of methods for making data more reliable and accurate. Usually companies store data in warehouses so they can make meaning out of...
Hakoonamatata
- Jul 9th, 2007
Data cleaning is a self explainatory term. Most of the data warehouses in the world source data from multiple systems - systems that were created long before data warehousing was well understood, and ...
-
OOAD Object Oriented Analysis & Design
When is the need to do OOAD (Object oriented analysis & design)
subang
- Jan 17th, 2010
We use OOAD in order to design the system when overall requirements needed for developing the new system are clearly understood by the developer.
-
Data Mart Data
Is data, transient or periodic in data mart? Explain
ashishsinha.dummy
- Nov 10th, 2009
Data marts are part of OLAP system. Data in datamarts cannot be trasient. Data will be updated in datamarts on a periodic or daily basis depending on the design of the data warehouse.-Ashish
-
What is the application of data mining tools?
-
SCD types and usages
What are the SCD types and what are its Usage?
pradeep16
- Oct 21st, 2009
SCD - Slowly Changing Dimensions. SCD usages in data warehouse are to store the history of transactions on dimensions. There are three types SCDs: Type1 - Just rewrite the record if there is a change...
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans