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

What is _n_?

Accenture,

23 39684

Whats the difference between $, $$, $$$

9 45735

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 16217

What is Factless fact table ???

Satyam, Tech Mahindra,

12 45346

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

CTS, TCS,

8 37001

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 8724

How will u find weather dimension table is big in size of a fact table?

1 7253

How will u pas the data with out debugger?

4 8582

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 15092

I have 1200 records how can u send it in aggregator with good performance issues?

3 9545

what is the logic will you implement to load data into a fact table from n dimension tables?

TCS,

4 19855

Why is meant by direct and indirect loading options in sessions?

4 24252

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 9101

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

TCS,

8 25103

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 13259

Un-Answered Questions { Data Warehouse }

Explain why fact table is in normal form?

981

explain the key concept of sas? : Sas-administrator

1019

What do the put and input function do?

1079

can anybody tell me about complicated object you have created

3243

What is informatica etl tool?

1013

How will I be charged and billed if I use Amazon Redshift?

List down the reasons for choosing sas over other data analytics tools.

1297

Which are the statements whose placement in the data step is critical?

1280

What is the difference between static cache and dynamic cache?

1008

What is the function of aggregator transformation?

1097

Hi friends, what are the new features in abinito3.0?

2815

Give e an example of..

2107

What are different types of joins that are possible in obiee rpd?

852

How can informatica be used for an organization?

1233

Do you view contain data?

959

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