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 standard environment ?

2 12456

. How we can remove temp files of a failed job if .rec is not available

2 11636

11. What is the use of allocate()?

TCL,

1 10635

What is the diff between abinitiorc and .abinitiorc files ?

TCL,

1 6781

What is air-project parameter ?

2228

Can you run air sandbox run using pset ?

2 18474

How you can create cross joined output using join component ?

3 11200

How you can run a component for certain conditions ?

1 11865

Broadcast and replicate does the similar work , what’s the diff then

TCL, Wipro,

4 21892

How can you export a component’s internal parameters ?

TCL,

2404

How you can test a dbc file ?

TCL,

1 13927

What is the significance of ‘mp run’ command ?

TCL,

1 10447

. How can you run a graph continuously without using continuous components ?

TCL,

3 13550

. How can you get all the fields form a lookup files ? (Which function)

TCL,

3 11788

) Diff.between Output index and Output indexes?

TCL, TCS,

4 37127

Un-Answered Questions { Data Warehouse }

What is the difference between olap and datawarehosue?

957

What would you consider as your biggest achievement and why?

1012

What is a general purpose scheduling tool?

1115

How do I create and delete a cluster in aws redshift?

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1100

Why we use repository connectivity?

984

How would you copy the content of one repository to another repository?

1024

Explain reference cursor?

2169

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2801

how will you locate the sas platform applications? : Sas-bi

1034

Why do we need informatica?

998

what is sas application server? : Sas-di

1083

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.

3477

What is the need for an etl tool?

1068

How do you update the records with or without using update strategy?

1117

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