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 9232

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,

2076

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 23168

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

1 9699

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 4907

Can we create universe with no cache??

1 6097

how can we build one report from two data bases

IBM,

4 8970

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 5724

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

Mind Tree,

5 12101

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

IBM,

3 17121

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

1 4014

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

3 29270

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

2 8461

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 11267

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

3 24549

Un-Answered Questions { Data Warehouse }

how do u catch bad rows from OCI stage? And what CLI stands for?

2856

Explain difference between e-r modeling and dimentional modeling?

1040

Explain informatica architecture - version 8 / 9

1155

what are slowly changing dimensions? Why we are used scd?

1187

how we can generate cubes in cognos?

Explain what are the different types of transformation available in informatica.

1252

What is the use of fallback?

1039

Explain load alternative records / rows into multiple targets - informatica

1208

What is the difference between metadata and data dictionary?

1224

Terminate Activity

1343

Which columns go to the fact table and which columns go the dimension table?

1028

What is the function of surrogate key in data warehousing?

1139

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

1405

What are the supported languages for microstrategy intelligence server?

1082

what is data modeling?

1953

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