Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

1062

What is dimension modeling?

1207

What is the difference between mapping parameter & mapping variable in data warehousing?

1055

Where the cache files stored?

1074

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1151

How can we run the graph? How can we schedule the graph in unix?

1007

What is the difference between star and snowflake schemas?

1332

What is loop in data warehousing?

1213

How do you create surrogate key using ab initio?

1060

What are fact, dimension, and measure?

1426

What are the difference between snow flake and star schema?

1070

How can we schedule the graph in unix?

1048

I have two universes created by two difference database can we join them in designer & report level? How

1054

What is critical column?

1275

What is "method/1"?

1168

Un-Answered Questions { Data Warehouse }

Explain what is informatica metadata and where is it stored?

1118

What are stage variables and constants?

1205

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2525

What is the difference between validated and compiled in the datastage?

1386

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1136

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3558

how can we create rank using datastage?what is the meaning of rank?

8870

How to eliminate duplicate rows from flat file?

1001

What are the fundamental blocks of co> operating system of ab initio?

1321

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1160

What is the difference between user and versatile user?

1152

What are the data types present in bo?

1218

Is it possible to define a single node as a Gateway node as well as worker node?

1188

Where $mpjret is used in ab-initio?

1205

Explain what are necessary tasks to install reportnet software?

980

For More Un-Answered { Data Warehouse } Questions Click Here