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

how remove 1st 3 records & last 3 records in informatics

4 9798

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

TCS,

2 5452

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

TCS,

1 5117

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

IBM,

2 17045

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

IBM,

1994

What is instream data in SAS?

1 5023

what is in stream data in SAS?

1 6696

what is study design in while working with SAS? what are screening variables in SAS?

MSCR,

2253

how to handle in stream data containing semicolon in it?

3 6518

which stats created by proc means that are not created by proc summary or vice versa?

GSK,

2 6429

What are types of transport files?

PRA Health Sciences, Quintiles,

2 8023

How to convert .xls file into CSV format?

Quintiles,

6 22892

How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?

GSK, TNS,

7 12743

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2420

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

TCS,

1 7289

Un-Answered Questions { Data Warehouse }

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2442

Where do we use mapping variables in informatica?

1082

How do you add a number to a macro variable? : sas-macro

1025

how many types prompting framework can be broken down to? : Sas-bi

1090

If you want to use the same piece of code in different jobs, how will you achieve it?

1170

What is the difference between user and versatile user?

1085

How to add a number to a macro variable?

1007

Tell me about MD5 functions in informatica

936

How scientific data processing is different from commercial data processing?

1094

How do we call shell scripts from informatica?

1135

What is non-aggregate metric?

1030

name the prompt which are available in cognos?

what is degenerate key in oracle ?whare do we use it?

2575

Is there any way to read the ms excel datas directly into informatica?

1031

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7272

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