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

Aborted in Phase 2 data acquistion completed in fastload?

2 5926

Fast Load Script is failed and error tables are available then how do you restart?

TCS,

3 15421

How do you Generate Sequence in Teradata?

TCS,

3 16339

How do you Generate sequence at the time of Display?

Infosys,

2 8588

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

IBM,

4 9427

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 13086

Why Multiload does not supports USI and supports NUSI?

4 21888

what is the custome stage in datastage? how can we impliment that one? plz tell me

Accenture,

2420

How do we implement materialized view?when to use materialized view?

TCS,

1 7891

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

Polaris,

2 18719

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

1 4296

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

Patni,

3 9802

In which situations we can use normal and sparse lookup stages

IBM,

4 16106

where to select code page option?

TCS,

2 7251

How to run the Teradata jobs in unix environment ???

IBM,

4 17009

Un-Answered Questions { Data Warehouse }

Explain is fact table?

980

What is meant by a Least Cost Plan?

1122

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2166

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

978

Is redshift using primary keys for key-value storage?

What is a surrogate key?

1163

Explain the different types of data warehousing?

1042

how to generate the test data in sas without input data? : Sas-administrator

1188

What are the main issues while working with flat files as source and as targets ?

1227

Select the AWS service which is nosql database and serverless, minimal latency ?

Is AWS Redshift a stored procedures?

what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

3009

What is conduct>it?

1177

What is substr function?

1250

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1133

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