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

I want skip first 5 rows to load in to target? what will be the logic at session level ??

IBM,

1 7177

Demonstrate experience in maintaining quality process standards?

iGate,

2647

How to get the repeated values by using sql in sas ?

2 5745

What is factless fact schema?

3 7412

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8547

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

IBM, TCS,

7 11114

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 8780

How do you eliminate duplicates?

3 8238

how can u find out the datastage job is running on how many nodes

IBM,

7 23361

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

Quintiles,

9 13326

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 4367

can you apply grouping on crosstab?

CTS,

1 6838

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

CTS,

2 8910

how to convert crosstab into list?

TCS,

4 10023

data import to models, datastores,stored processed, is there any other way to import data?

TCS,

1 4379

Un-Answered Questions { Data Warehouse }

How do you optimize reports in microstartegy?

1166

how does sas handle missing values in sort order? : Sas programming

983

What are the different components of powercenter?

1119

Syntax for case when statement?

1118

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1318

What are the different types of join operations?

1056

What is meant by a Channel Driver?

1338

How you can differentiate between connected lookup and unconnected lookup?

1111

How do you load only null records into target? Explain through mapping flow.

2077

What are the various indexes in teradata? Why are they preferred?

1058

how many maximum session supports to multiload in teradata ??

2177

What is amazon redshift? How it work?

What are cognos connection initial page components?

1208

What are the common features of Redshift?

What are the different types of fact tables used in data warehousing?

1047

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