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

what r the filters in fwm and report studio

TCS,

6 15126

What is Cardinality

Cognizant, HCL,

6 26900

What is Report item

TCS,

1 6164

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

Accenture,

1 8172

how do we mail reports from SAS environment to our team leader

Wockhardt,

5 12863

What is the importance of Dimension in the cognos.

Hexaware, IBM,

3 11235

What is parameter maps & Session parameter?

4 39548

what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

Wockhardt,

2 8079

What is the use of Excel files in Cognos8?

1 6792

What is Stich Query in Reportnet?

10 22939

what are the new features included in the new version of SAS i.e., SAS9.1.3?

College School Exams Tests, Wockhardt,

5 10798

in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

iFlex,

1 8378

wat is difference b/w break and section?

4 22912

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

iFlex,

2 7097

2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?

iFlex, Patni,

1 6104

Un-Answered Questions { Data Warehouse }

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

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.

2811

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

1200

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

2421

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

What is dimensional table? Explain the different dimensions.

1267

Demonstrate experience in maintaining quality process standards?

2672

what are the dimensions that you have in your current project?list them?

2093

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

2104

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

1849

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

What sort of existing documents should business analysts refer to when starting on a new project?

1078

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

2093

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

2207

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