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

can anybody tell me when do use 'running total'...give an example for the usage of running total

2 9524

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.

HCL,

2731

where do we see the run time of the report ?

2 5853

I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?

4 8021

How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?

5 8225

can we create aliases for every table beforehand? if yes whar are the disadvantages?

AG Technologies,

5 10747

what are the disadvantages of alias?

Patni,

6 20213

WHAT IS ROW LEVEL SECURITY IN BO?

Wipro,

7 24522

What is security level in BO ?

Accenture,

3 10395

Can we create a web page where the report directory and the output can be viewed directly across cognos connection?

TCS,

2 6888

Which service handles requests for cognos connection,query studio and event studio.

TCS,

2 10987

plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 5710

how to do Ad-hoc reporting ?

IBM,

6 13029

i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 6766

Is cognos models are version compatible?

2 5063

Un-Answered Questions { Data Warehouse }

What are components of reportnet?

1096

Explain is olap databases are called decision support system true/false?

1018

How will you monitor the errors received while running i-server and report?

959

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1970

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

1025

how do u extract data from different data sources explain with an example?

2265

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2072

How might one distinguish in the case of mapping is right or not without associating session?

1141

Explain what is informatica metadata and where is it stored?

1063

Explain PDL with an example?

1334

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2630

Does datastage support slowly changing dimensions ?

1119

What is etl process?

952

What are the various types of transformation?

1197

what is document design in boxi,have u participate in that

2205

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