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

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

UHG,

4 10794

HI,can one suggest best institute for cognos Training in Hyderabad

14 22031

How to restrict the user to refresh or Run the report only 1 time in BO?

Perot Systems,

6 11099

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

TCS,

1 4173

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

Cap Gemini, Infinity, TCS,

2 14535

How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

Cap Gemini, TCS,

1 6321

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

L&T,

1 15475

What is different between informatica version 8 and 9 version

Cognizant, IBM,

1 3461

I have 5 different country names and their currencies like India-Rupee, USA-Dollar etc. when I run the report, the report should display only either currencies or country names.How to run the report?

L&T,

3 7740

The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?

L&T,

2 6307

Explain about Microstrategy Report execution process?

L&T,

1 6470

Is it possible to Delete duplicate rows at row level?

2 6807

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2240

Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

Icon,

1 3260

Intelligent cube is a public object or schema object in microstrategy?

HTC,

3 10908

Un-Answered Questions { Data Warehouse }

How to generate sequence numbers?

1099

In sas, what are the areas that you are most interested in? : sas-grid-administration

1091

Explain heterogeneous mapping?

995

Explain the informatica workflow?

1083

What is data modeling and data mining?

985

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1944

What are sequencers?

1131

What are all types of Batches?

1038

What are the various methods of getting incremental records or delta records from the source systems?

944

List out some of the air commands used in abintio?

1395

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2378

What is prompt types of prompts?use of prompts syntax of prompt?

1355

Explain what is fact less fact table? Where you have used it in your project?

943

what is sas database server? : Sas-di

1148

What are different table types used in teradata?

1059

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