-
-
What is data validation strategies for data mart validation after loading process
kalpit
- Mar 10th, 2009
Data validation is generally done manually in DWH, in this case if source and TGT are relational you need to create SQL scripts to validate source and target data, and if source is Flat file or non re...
uma
- May 3rd, 2006
Data validation is to make sure that the loaded data is accurate and meets the business requriments.Strategies are different methods followed to meet the validation requriments
-
What are the steps to build the datawarehouse
Sravan Kumar Gopisetty
- Sep 1st, 2006
1.Understand the bussiness requirements.2.Once the business requirements are clear then Identify the Grains(Levels).3.Grains are defined ,design the Dimensional tables with the Lower level Grains.4.On...
prashanthmcr
- Aug 29th, 2006
You can also the book "The Datawarehouse Toolkit" By ralph kimball and margy ross. I found it extremely helpful.PrashanthCheck the website www.intelligententerprise.com . It is quite informative and has very useful articles.
-
What is the differences between the static and dynamic caches?
ramakrishna.inf
- Apr 21st, 2009
Static cache - It doesn't reflect changes once data is cached is known as static cache.
Dynamic cache - It reflect to changes at the time of running the session if any updates happen in source data.jayadhar
- Sep 4th, 2006
static cache stores overloaded values in the memory and it wont change throught the running of the session where as dynamic cache stores the values in the memory and changes dynamically duirng the run...
-
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...
-
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 meant by Aggregate Factable?
Factable having aggregated calculations like sum, avg, sum(sal)+sum(comm),these are Aggregated FactableCheersPadhu
ThomasB
- Jan 4th, 2008
An aggregate fact table stores information that has been aggregated, or summarized from a detail fact table. Aggregate fact table ares useful in improving query performance. Often an aggre...
-
What is Replicate,Transparent and Linked cubes?
mri_sonam
- Dec 18th, 2008
Linked CubeA cube can be stored on a single analysis server and then defined as a linked cube on other Analysis servers. End users connected to any of these analysis servers can then access the cube. ...
-
-
-
-
How do you load the data conditionally by run steps ?
DWH01
- Jul 8th, 2008
This depends upon how the ETL is done:If we are loading data using Informatica, the workflow jobs can be scheduled using Autosys or any other scheduler, in which the scripts could check for the condit...
-
-
Maintain Dimensions - ETL or Data Entry
For a Customer or Product Dimension with 500,000 rows changing daily an ETL solution is the only sensible way forward. But surely you shouldn't ETL every single Dimension table - especially if there's over a hundred of them, and they're are static, error prone or manually enhanced? What would you advise / normally do ?
mri_sonam
- Dec 17th, 2008
If you are designing a Data Warehouse how can you rely on manual process? better way is to use ETL wherever required or else just extract and load.But you should refresh all your dimensions regularly ...
-
What is CGID in normalizer transformation
Please provide me deep info on Normalizer !
Sirini
- Jun 14th, 2009
It is GCID which means Generic Column ID. When a Normalizer transformation is used to read Cobol sources, the Informatica Designer identifies the 'OCCURS' and 'REDEFINES' statements and generates 2 co...
-
Transformation keys into generic key by system itself is called as
aquacooldude
- Feb 19th, 2009
The transformation of keys which are supposed to be used as primary key into generic key by the system is called as key restructuring. The problem is something like this, let us a say there was an ex...
-
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.
-
Data Mart Entity
If data is missing that is required as a primary key in a data mart entity from what sources can this information be gathered?
preekon
- Aug 24th, 2010
Data mart is considered to be a subset of datawarehouse, If the data is missing for primary key and the data source can be gathered from the list of entity derived from dimensions, but data mart ...
Data Warehousing Basics
Ans