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 11009

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

14 22610

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

Perot Systems,

6 11334

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

TCS,

1 4266

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

Cap Gemini, Infinity, TCS,

2 14659

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 6418

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 15578

What is different between informatica version 8 and 9 version

Cognizant, IBM,

1 3576

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 7904

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

L&T,

2 6420

Explain about Microstrategy Report execution process?

L&T,

1 6562

Is it possible to Delete duplicate rows at row level?

2 6956

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

2304

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 3341

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

HTC,

3 11088

Un-Answered Questions { Data Warehouse }

What is the difference between business requirement document and use case document.

1088

What are the data types present in bo? What happens if we implement view in the designer and report?

1083

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2268

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2423

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

Hi, If anyone has base SAS certification dumps, please share.

1944

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

Are you involved in writing the inferential analysis plan? Tables specifications?

4021

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2819

How would you format some text using css to be verdana and bold?

1150

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2772

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2153

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1855

What is a rollup component? Explain about it.

1246

Explain about a tricky situation for which you found a very simple solution?

1081

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