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

which date function advances a date, time or datetime value by a given interval? : Sas programming

996

name several ways to achieve efficiency in your program? : Sas programming

987

how does sas handle missing values in sort order? : Sas programming

874

what versions of sas have you used (on which platforms)? : Sas programming

1006

how could you generate test data with no input data? : Sas programming

1117

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

987

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1095

how does sas handle missing values in functions? : Sas programming

1129

why is sas considered self-documenting? : Sas programming

1084

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1082

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1017

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1279

do you prefer proc report or proc tabulate? Why? : Sas programming

935

what is the effect of the options statement errors=1? : Sas programming

1003

how would you create multiple observations from a single observation? : Sas programming

954

Un-Answered Questions { Data Warehouse }

Identifying the bottlenecks in various components of Informatica and resolving them.

1872

Which is the t/r that builts only single cache memory?

1130

Explain the difference between a data warehouse and a data mart?

1002

Mention common programming errors committed in sas ?

1064

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

889

what other sas products have you used and consider yourself proficient in using? : Sas programming

1059

How to get sql from obiee for reports?

821

what is online view?

1892

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2058

How to a create header dynamically in a crosstab report in cognos 8.1?

2381

What does role playing dimension mean?

1002

During the Display time, how is the sequence generated by Teradata?

973

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2057

What is meant by a node?

995

What do you mean by static prompt report?

936

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