DWH01

 Profile Answers by DWH01 Questions by 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...

Answer Question  Select Best Answer

Ankit Kansal

• Feb 15th, 2014

INFORMATICA is a data integration and warehousing tool which prepares data from different sources to a stream line flow after which a tool like OBIEE uses that data to display reports in several formats e.g. Charts & Graphs

Answer Question  Select Best Answer

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

 Profile Answers by mri_sonam Questions by 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 ...

Answer Question  Select Best Answer

Please provide me deep info on Normalizer !

Sirini

 Profile Answers by Sirini Questions by 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...

Answer Question  Select Best Answer

aquacooldude

 Profile Answers by aquacooldude Questions by 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...

Answer Question  Select Best Answer

What do you mean by Transmission Media? Describe various types of Transmission Media.

shreya890

 Profile Answers by shreya890 Questions by 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

Answer Question  Select Best Answer

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

 Profile Answers by charlie2k Questions by 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. 

Answer Question  Select Best Answer

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

 Profile Answers by preekon Questions by 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 ...

Answer Question  Select Best Answer

Give an example of non-additive facts?

rummyraj

 Profile Answers by rummyraj Questions by 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...

Answer Question  Select Best Answer

RathiRam

 Profile Answers by RathiRam Questions by 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...

Answer Question  Select Best Answer

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...

deokant

• Jan 18th, 2012

service requirement means establishing the connection between client and server...right? well if it is then i can guide you that how to connect a client machine to server via repository. once the ser...

Answer Question  Select Best Answer

what are homegeneous sorces and heterogeneous data sources ? Is flat file different from those two

Sreedhar Lokaray

• Nov 3rd, 2011

The dictionary meaning of Homogeneous is Uniform and Heterogeneous is Mixed. For example if a mapping is using only Oracle sources or Flat files or DB2 or XML or any other then they are called Homogen...

Answer Question  Select Best Answer

what is high level document(HLD),lowlevel document(LLD),MAPPING documents ? what is the stuff they contains?

Sarat

• Nov 13th, 2014

High Level Design document will prepare by the Data Modeling people to generate the required data warehouse schema for the ETL purpose. LLD : Low Level Design is the design document which will be use...

Answer Question  Select Best Answer

surrogate key is nothing but a primary key , but Does have any business meaning

avinash

• Apr 16th, 2016

Surrogate key is a key that is generated by a system and its has unique values.

Answer Question  Select Best Answer

What relationship is resolved by an intersecting or associative entity ?
a) Recursive
b) Mandatory one to one
c) Many to Many
d) One to One

Nagireddy

• Sep 27th, 2019

Recursive

Answer Question  Select Best Answer

Answered by Satish on 2005-04-29 08:20:29: The Aggreation or calculated value colums will go to Fac Tablw and details information will go to diamensional table.

ravi kumar guturi

• Mar 9th, 2006

Before broken into coloumns is going to the factAfter broken going to dimensions

sudhir

• Aug 4th, 2005

To add on, Foreign key elements along with Business Measures, such as Sales in $ amt, Date may be a business measure in some case, units (qty sold) may be a business measure, are stored in the fact table. It also depends on the granularity at which the data is stored

Answer Question  Select Best Answer

Kenneth

• Jul 18th, 2005

An DW is typically used most often for intensive querying . Since the primary responsibility of an OLTP system is to faithfully record on going transactions (inserts/updates/deletes), these operations will be considerably slowed down by the heavy querying that the DW is subjected to.

Nirav

• May 15th, 2005

Data Warehouse is a part of OLAP (On-Line Analytical Processing). It is the source from which any BI tools fetch data for Analytical, reporting or data mining purposes. It generally contains the data...

Answer Question  Select Best Answer

kalpit

 Profile Answers by kalpit Questions by 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

Answer Question  Select Best Answer

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

 Profile Answers by prashanthmcr Questions by 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.

Answer Question  Select Best Answer

ramakrishna.inf

 Profile Answers by ramakrishna.inf Questions by 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...

Answer Question  Select Best Answer