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 bobble chart?

Syntel,

1 5992

how can you get the errors in job? when loops are araised we get error?

Syntel,

2171

what is stitch query?

Syntel,

2 8882

what is materialised view? why we use it in data warehousing?

HCL,

5 10707

what is view? types of views?

HCL,

3 8199

what is online view?

HCL,

1997

how can you create a report like if country=india then true if contry=spain then false?

Syntel,

2 6189

what is your project workflow and your role in the project?

Syntel,

5 11862

difference between stored procedure and function?

Syntel,

4 9340

how many types of formats you can run a report using cognos?

HCL,

4 10347

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

HCL,

1 5048

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

HCL,

2147

what does my folder and public folder contains? difference between the my folder and public folder?

HCL,

3 9712

what is a join? what are the types of joins?

HCL, Satyam,

5 10481

what is an outer join? difference between left outer join right outer join with an example?

HCL,

1 11145

Un-Answered Questions { Data Warehouse }

Explain what is the use of proc gplot?

1251

Mention what dedup-component and replicate component does?

1089

Which component has onread method and what it is used for?

1040

What is a source qualifier?

1169

Can anyone tell me the new features in Informatica 9 Version?

2225

Is it possible to access Redshift compute Nodes directly?

Can you run multiple rpd’s in a single obiee instance?

845

What is the function of union transformation?

1211

How do you verify a complicated sql?

1119

Can we get 1st record through Informatica(without sequence number).

1527

What is upsert statement in teradata?

1206

Highlight the limitations of TPUMP Utility.

1186

How do you ensure simultaneous releases across multiple operating systems?

1020

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

1024

What are the six data process products of ab initio (architecture of ab initio)?

1179

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