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 5934

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

TCS,

3 15425

How do you Generate Sequence in Teradata?

TCS,

3 16346

How do you Generate sequence at the time of Display?

Infosys,

2 8593

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 9428

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

4 13095

Why Multiload does not supports USI and supports NUSI?

4 21901

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

Accenture,

2421

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

TCS,

1 7893

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 18721

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 4297

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 9808

In which situations we can use normal and sparse lookup stages

IBM,

4 16112

where to select code page option?

TCS,

2 7254

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

IBM,

4 17018

Un-Answered Questions { Data Warehouse }

What are slice and dice?

980

What is degenerate dimension table?

1055

How to create or import flat file definition in to the warehouse designer?

1145

What is a folder? Difference types of stages?

1247

what is sysdba and sysdbc ? which has high priority ?

3891

What is a mapping?

1059

How many input parameters can exist in an unconnected lookup?

1605

What is the benefit of partitioning a session?

1244

define feeders?

What is afc?

1065

What are the available primary index types?

1286

What are snapshots?

1036

How many ways are there to create ports?

1412

What is difference between data mart and data warehouse?

1028

What is meant by Reportstudio shortcut?

2231

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