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 5589

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 2952

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

2 5443

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 12308

what is Active lock explain

Satyam,

2807

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

TCS,

1 10686

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

TCS,

1 11993

What is CDC? How to implement CDC?

People Tech, TCS,

4 23551

Tell me about informatica architecture.

TCS,

2 9649

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 3847

What is Indexing? how did u implement indexing?

TCS,

2480

How to convert HTML file into SAS dataset?

2942

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

iGate,

6 12158

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

iGate,

7 12720

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

iGate,

5 11112

Un-Answered Questions { Data Warehouse }

How is MLOAD Teradata Server restarted after execution?

1270

What is the need for an etl tool?

1070

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1981

How many dimensions are there in informatica?

1096

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2557

what do u mean by bridge group? where we r using this one?

1992

What Amazon redshift built for ?

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1067

tell me two or three issues from client side and how to solve those issues?

2171

What are the design methods of data warehousing?

956

What is the use of target designer?

1059

What do you understand by a cartesian join?

1125

How conflicts occur and what are the ways to resolve them?

965

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1171

How to call shell scripts from informatica?

1001

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