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

how to unlock a locked job in datastage 8.0

3 23331

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

Cognizant, Wipro,

7 15307

hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....

1 4924

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

Altisource, Patni,

1 9795

What is synonym?

Patni,

2 6058

what is lookup chache?

Patni,

1 4808

what is the mechanism of the Master-Detail joining condition?

IBM, Patni,

6 10184

Do joiner transformation use cache? If so describe?

Patni,

2 6948

what is materialized view?

2 5204

How will you check the bottle necks in informatica? From where do you start checking?

HCL,

3 7844

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

HCL,

8223

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

how to remove duplicates in transformer stage by using stage variables?one example?

Syntel, TCS,

6 33662

Can we Save (save as) WEBI Doc as DESKI?

HCL,

2 8180

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 5544

Un-Answered Questions { Data Warehouse }

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2126

name the prompt which are available in cognos?

explain in detail about type 3?

1017

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2149

Explain about round-robi?

1153

What are the reasons to use a chameleon method in data warehousing?

1057

What is edw?

1200

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2172

Mention how to limit decimal places for the variable using proc means?

1120

how to load the data to fact table?

2705

Which are the olap tools available that are supported by oracle?

937

What are aggregate tables and aggregate fact tables?

1040

Explain what is the difference between slice and dice and cross tab report?

1081

which type of project we r going to snowflake schema

1978

what is a security filter?

999

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