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 9505

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,

2721

where do we see the run time of the report ?

2 5829

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

4 7992

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

5 8196

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

AG Technologies,

5 10702

what are the disadvantages of alias?

Patni,

6 20148

WHAT IS ROW LEVEL SECURITY IN BO?

Wipro,

7 24463

What is security level in BO ?

Accenture,

3 10355

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

TCS,

2 6866

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

TCS,

2 10959

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 5687

how to do Ad-hoc reporting ?

IBM,

6 12982

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 6742

Is cognos models are version compatible?

2 5030

Un-Answered Questions { Data Warehouse }

------------------What is Inline Query?

2223

What is a real-time data warehouse?

998

How are numeric and character missing values represented internally?

1659

What is an i-server?

1057

wat are deployement groups in informatica, how it will be used for developers

1719

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

1776

What is Additive function?

2031

What are the different types of partition components in abinitio?

1347

What are the special input delimiters used in SAS?

1181

How to eliminate product joins in a teradata sql query?

1029

Mention what is the syntax for m_dump in abinitio?

1471

How to do unit testing in informatica?

1171

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1106

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

Do you think effective communication is necessary for data processing?

1219

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