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 is the pound sign used for in the data_null_ ?

1 3664

For what purpose(s) would use the RETURN statement?

1 8180

How would you determine how far down on a page you have printed in order to print out footnotes?

3 9889

How would you include common or reuse to be processed along with your statements?

1 2439

Why is a STOP statement needed for the point=option on a SET statement?

Quintiles,

2 13269

How would you remove a format that has been permanently associated with a variables?

3 10496

Briefly describe 5 ways to do a "table lookup" in sas.

Quintiles,

4 21394

If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

HCL, Quintiles,

1 9720

How can you put a "trace" in your program?

Quintiles,

2 10916

Are you sensitive to code walk-throughs peer review or QC review?

Quintiles,

1 3218

What other SAS features do you use for error trapping and data validation?

2 12423

What has been your most common programming mistake?

Wipro,

4 11359

Which date functions advances a date time or date/time value by agiven interval?

3 8041

How would you keep from overlaying the a SAS set with its sorted version?

4 9873

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 21279

Un-Answered Questions { Data Warehouse }

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

2173

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

Demonstrate experience in maintaining quality process standards?

2669

what are the data modeling tools you have used?(polaris)

2057

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

4018

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

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

1201

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

1847

Hi friends, what are the new features in abinito3.0?

2858

what are the names of the reports that you prepared?

1192

What is rollup component?

1330

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2432

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!!!

2257

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

2168

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