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

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 9135

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2042

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 22950

How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 9621

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 4827

Can we create universe with no cache??

1 6024

how can we build one report from two data bases

IBM,

4 8816

data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat

2 5628

How many mapplets u have created? and what is the logic used

Mind Tree,

5 11931

why do we go for update strategy tr in SCD rather using the session properties?

IBM,

3 16991

The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 3947

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 29124

Is it possible to design report layout in crystal reports without Database info?

2 8330

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

Hexaware,

3 11150

What is the difference between In-Memory Sort and Inputs must be sorted?

3 24373

Un-Answered Questions { Data Warehouse }

What are vaious etl tools in the market?

1004

Why redshift Distribution key is used?

Explain some differences between mpp and smp?

1104

What are the default statistics for means procedure?

1245

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

911

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

923

How might you approve all mappings in the archive all the while?

1018

what is sas metadata server? : Sas-di

1107

Explain about alerts in bos, under what situation we need to use alerts?

1053

Explain the difference between etl tool and olap tools?

908

Explain proc univariate?

1033

How can you force the optimizer to use a particular index?

1061

What is joiner transformation?

1010

Can you define framework manager?

1032

How to reverse the string using SQL?

1533

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