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 10768

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

14 21977

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

Perot Systems,

6 11083

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

TCS,

1 4163

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

Cap Gemini, Infinity, TCS,

2 14527

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 6316

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 15465

What is different between informatica version 8 and 9 version

Cognizant, IBM,

1 3455

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 7728

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

L&T,

2 6296

Explain about Microstrategy Report execution process?

L&T,

1 6462

Is it possible to Delete duplicate rows at row level?

2 6793

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

2231

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 3245

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

HTC,

3 10887

Un-Answered Questions { Data Warehouse }

Explain about hash partitioning?

1004

define over feeding?

What would be the next step after collecting the data?

1199

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9832

Explain teradata vs. Redshift?

1032

what is the basic structure sas administrator? : Sas-administrator

1009

What are the available primary index types in teradata.

1034

Can we change Dynamic to Static or Persistent cache? If so what happens?

2215

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1893

what is data governance? : Sas-di

1027

How do you load only null records into target? Explain through mapping flow.

2033

how tokens will generate?

2210

What is the role of unrestrictive users? : sas-grid-administration

1012

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2225

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

997

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