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

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 5604

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 2962

. User wants to modify a report and wants to add additional data. How will you approach.

2 5453

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 12331

what is Active lock explain

Satyam,

2816

What are the different types of code pages available in informatica & how to implement it in your project?

TCS,

1 10697

What is the difference between unicode & ascii mode data movement in informatica?

TCS,

1 12004

What is CDC? How to implement CDC?

People Tech, TCS,

4 23570

Tell me about informatica architecture.

TCS,

2 9666

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

Accenture,

1 3858

What is Indexing? how did u implement indexing?

TCS,

2490

How to convert HTML file into SAS dataset?

2946

write a query for how to eliminate the duplicate rows without using distinct?

iGate,

6 12184

how to get the first row without using rank t/r?

iGate,

7 12748

what is the command to get the list of files in a directory in unix?

iGate,

5 11137

Un-Answered Questions { Data Warehouse }

What are the benefits of data analyzing?

1202

What is joiner change?

1159

define cognos connection?

What’s the difference between var b1 – b3 and var b1 — b3?

1376

list out all the transformations which use cache?

1194

Describe the ways in which you can create macro variables?

1209

What is the role of co-operating system in abinitio?

1470

What do you understand by the term 'model durability'?

1031

what are the different types of fact structures?

1115

What is the main difference between star and snowflake star schema? Which one is better and why?

1044

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1503

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2096

Where is tm1 web logging information found?

Differentiate between joiner and lookup transformation?

1115

how many modules are there in telecome domain?how to explain the architecture?

2032

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