-
If you source data from a system that you (warehouse team) have no authority to enforce data quality at the source level, how do you handle this? Do you apply data validation just after you stage the data? Or do you enforce it at the “end” of the flow (typically as you’re pushing it into the data mart)? Or do you not enforce validation at all?
Dominique
- Sep 10th, 2009
A DW is no longer relevant when it contains inconsistent data. The strength of a DW - and its robustness - also relies on the validation processes... The sooner you can detect and report any inconsist...
Nitin
- Mar 17th, 2007
One of the main purpose of Datawarehousing is to get Cleanse data.So skipping data validatons is not a good idea.It will be better to bring the data to a staging area and perform validations.Or while pushing data from the source we can perform data validations.
-
ETL Load Frequency and Load Window
What is Load Frequency and Load Window in ETL?
zann1
- Sep 7th, 2009
ETL Load frequency is how often the ETL processes (that load data into the data warehouse) are run.Load Window is the time allocated for ETL load to execute.e.g. If the load is run daily, and the time allowed for execution is 8 hours then:ETL load frequency = dailyLoad window = 8 hours
-
Lookup Performance
How does the usage of Dataset improve the performance during lookups?
sixto.dsilva
- Aug 17th, 2009
Correct me if i misunderstood your question. I think you want to know whether the usage data will improve the graph performance. I think definitely the usage of data will definitely improve the graph ...
-
Data Warehouse as Transaction Database
Can a Data Warehouse also be used for Transaction Database? If Yes Why, If No Why not?
sixto.dsilva
- Aug 15th, 2009
As the definaton of Datawarehouse say it is repository of historial data which is used by Busines users to run some reports on his/her area of interests.Data is not loaded everyhour or every mtes in D...
SQLGal
- Jun 7th, 2009
No, a data warehouse cannot by definition be used as a transaction database. A data warehouse is "read only" data that does not change once it has been loaded and used for informa...
-
Reconcialation Process
What is the Reconcialation Process?
v_madhu29
- Aug 11th, 2009
Reconcilation process is a systematic comparision between the data in Dataware house and data in source system.The comparision may be a set a predefined summary values or detailed data periodically.
-
Use of ROLLUP and CUBE
What is a use of ROLLUP and CUBE in ORACLE? How do they help Data Warehousing applications?
-
Multi-Valued Dimension
Illustrate one detailed example for multi-valued dimension or bridge table?
ramanapaidi
- Jul 1st, 2009
Health care bill has line item of diagnosis, for which there could be multiple values
-
Mimic Diagram
What is meant by mimic diagram? Where it is used?
-
What is the difference between mapping parameter & mapping variable in data warehousing?What are the types of variable available in data warehousing?
dhiveya.m
- Apr 22nd, 2009
Mapping parameter are the constant values (values never changes) and mapping variables are the values that ever changes.
fir_dan
- Jul 18th, 2008
A mapping parameter is a static value that you define before running the session and it retains the same value till the end of the session. Define a parameter in paramaeter file (.par) and use it in m...
-
Data Warehousing Life Cycle
What is the life cycle of Data Warehousing in Real-time?
-
Data Table Compare Values
How to compare values in data table?
-
Data Warehouse Security
How data security is provided in Data Warehouse?
-
DataStage TX
What is DSTX?
mercmorrow
- Jan 21st, 2009
Probably a late answer now, but... Datastage TX a rebranding of the Mercator runtime(Event Server) application by the (then) owners Ascential.Since then IBM have taken over Ascential, and the product ...
-
ERWIN Tool Model Print
If you take a print out of your model in ERWIN tool, What all you will be able to see?
rajeshkumar.san
- Dec 26th, 2008
According to the selection of print we can view in the print out. we will be able to view all the tables with their feild name, primary key, datatype, relation between the tables and their flow.
-
How Many different schema's or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE. Any other model that can be used??
uma
- May 17th, 2007
There are 3 types of schemasstar schemasnowflake schemaand galaxy schemabyuma
-
Version Control
How to use version control. What are the options which is use in the version control
-
Content Store on Network
How to create content store in the network and how to connect the remote database?
-
-
Pivot Table inside Informatica
How to Pivot a table inside informatica?
Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting (Target Table)ID Value A Value B1 10 20How can this be achieved inside informatica?devidya
- Sep 25th, 2008
Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best.
-
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans