GeekInterview.com
Series: Subject: Topic:

Data Warehousing FAQs

 
Sub Categories (+ View)
Subject Name
Questions
Answers
Last updated
117
102
Jul
18th,
2012
91
50
Apr
8th,
2013
12
9
Jul
15th,
2009
Showing Questions 1 - 20 of 82 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Use of unused port in join component.

Asked By: Emanisreddy | Asked On: Apr 17th, 2012

What is the use of the unused port in the join component? We have reject port. Difference between the reject port & unused port?

Answered by: anshuman trivedi on: Mar 3rd, 2013

Hi, Answer of question is as following. 1)Reject Port:it will contain all the rejected record,here rejection does not means those records which does not follow the join condition,here comes those reco...

Hyperion oce

Asked By: gurramraju | Asked On: Aug 7th, 2008

How to create a oce (open catalog extension) in hyperion?

Answered by: Shanmuagapriya K on: Feb 3rd, 2013

Launch IR Studio--Tools---Connection--Create.

Informatica project overview

Asked By: Arpita Soni | Asked On: Jan 31st, 2013

As I am new to Informatica. Can anybody tell me about real time Informatica project in detail(step by step). Explain it by giving example.

Master data

Asked By: maheshanna | Asked On: Jan 30th, 2013

Can any one explain about master data? And we use it frequently or rarely.

How to retrieve las ten or first ten rows from a flatfile

Asked By: amar_smmath | Asked On: Sep 27th, 2007

Answered by: Praful on: Dec 17th, 2012

In datastage, we can use the External Filter stage, use the unix command head or tail to retrieve the particular lines from the flat file.

Answered by: ambika shanmugam on: May 20th, 2008

Using the SORT operation, we can retrieve the set of records from the flat file
 Sample command;

SORT FIELDS COPY
STOPAFT=10 (stop after 10th record)
SKIPREC=10 (skip first 10 records)
 

Types of dimension

Asked By: wadate | Asked On: Dec 8th, 2010

What are the types of dimensions? Can you explainthe each type in short?

Answered by: Joe on: Aug 21st, 2012

1. Conformed Dimensions
2. Junk Dimensions

Answered by: chandu on: Sep 21st, 2011

There are 3 types of dimensions.type-1,type-2,type-3.

type-1:it maintains only latest information.

type-2:it maintains both previous and updated information.in this surrogate key comes into picture.most of the cases we use this type.

type-3:it maintains partial history of data.

Database and data warehouse

Asked By: roselily | Asked On: Aug 17th, 2010

What is the relationship between company database and its data warehaouse?

Answered by: Rajarao marisa on: Jun 6th, 2012

Hi, The main diff between database and data warehouse------> DW 1)Its stores historical & Summarized d...

Answered by: prasadkawade on: Mar 20th, 2012

Company database contains all the current data. whereas the data warehouse of means data repository. Database stores all the data on which business runs but database repository contains the data that ...

Datastage

Asked By: rakesh.u45 | Asked On: May 18th, 2012

I have source like a,b,c 1,2,3 I want to populate the records in to target as follows a 1 b 2 c 3 can any body tell me how to solve the scenario by using transformer stage.(in data stages)

Pass records in flat file

Asked By: shalaka242 | Asked On: Jan 9th, 2011

How to pass first, middle and last record in flat file to flat file?

Answered by: KVR Prasad on: Dec 1st, 2011

By using sequence generator, Expression transformation and router T/R it will be possible.

Hyperion essbase dimension and hierarchy

Asked By: sbassoundar | Asked On: Jan 27th, 2008

What difference between dimension and hierarchy>what is mean by maxl?Difference between esscmd and maxl?If we are using only dense dimension in outline what will be effect of cube structure?

Answered by: Sahil on: Oct 25th, 2011

Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,

Answered by: karna.siva on: May 20th, 2008

A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc.  and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...

Replicate vs broadcast

Asked By: annegrace1 | Asked On: Apr 7th, 2009

What is the difference between replicate and broadcast ?

Answered by: chandana on: Sep 21st, 2011

replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.

Answered by: zann1 on: Sep 7th, 2009

Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usuall...

Ssas cube partition

Asked By: maruthiprasadsql | Asked On: May 25th, 2009

How to partition a cube in analysis services?

Answered by: Rambabu Kola on: Sep 7th, 2011

-->create cube using ssas and deploy it.
-->connect sql server management studio
-->then connect sql server analysing services
-->right click on cube and click partition
----------------------------------------------------------------
like this we can partition the cube..

Degenerated dimension

Asked By: sudhakar568 | Asked On: Feb 16th, 2011

When do we use degenerated dimension?

Answered by: pradeep reddy gade on: Jul 20th, 2011

Any values in the fact table that dont join to dimensions are either considered degenerate dimensions or measures

Central repository

Asked By: kumar_bods | Asked On: Dec 5th, 2010

What is the central repository? Is it possible to login from designer?

Prioritized rules

Asked By: Madhugreddy | Asked On: Nov 3rd, 2010

What are the prioritized rules in transform function?

Dynamic insert

Asked By: swapnabogolu | Asked On: Sep 6th, 2010

What is dynamic insert?

Answered by: mkm187 on: 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

Asked By: skyboyfli | Asked On: Aug 30th, 2010

How to get rejected data from the join stage without using any stages after join?

Fact table duplicates

Asked By: greek143 | Asked On: Aug 11th, 2010

How can we remove duplicates from fact table?

Custom dimensions

Asked By: greek143 | Asked On: Aug 11th, 2010

What is a custom dimension?

Autosys jobs schedule

Asked By: sgangra | Asked On: Apr 13th, 2009

How can we schedule our jobs in third party tool - autosys?

Answered by: saigarneni on: May 18th, 2010

We need to write shell script to run the job and write JIL on autosys to schedule the job

Answered by: varghesebinu on: 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...

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Business Objects FAQs

Cognos FAQ

ReportNet FAQ

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.