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 9630

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,

2796

where do we see the run time of the report ?

2 5947

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

4 8163

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

5 8387

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

AG Technologies,

5 10939

what are the disadvantages of alias?

Patni,

6 20420

WHAT IS ROW LEVEL SECURITY IN BO?

Wipro,

7 24763

What is security level in BO ?

Accenture,

3 10493

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

TCS,

2 7000

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

TCS,

2 11082

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 5850

how to do Ad-hoc reporting ?

IBM,

6 13238

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 6899

Is cognos models are version compatible?

2 5141

Un-Answered Questions { Data Warehouse }

Have you have ever worked in unix environment and why it is useful in datastage?

1210

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305

faq's on cognos

4108

how to generate the test data in sas without input data? : Sas-administrator

1193

What is rollup component?

1324

How to create the source and target database connections in server manager?

1139

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

2415

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2087

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1189

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

What is node? How many nodes and amps used in your previous project?

1167

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2201

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