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 are the vldb properties? Which level of vldb configurations have the highest precedence?

947

What are level metrics? Why are they needed?

1043

How does microstrategy object manager determine if two objects in different projects are the same?

1072

At which levels you can set the vldb properties? Which level has the highest pecedence?

956

Does microstrategy intelligence server support scheduling?

1053

What leads to a cross-join or how does a cross-join occur?

952

How can you make the sql query to be based on a specific table of your choice?

1064

To save time, can many reports be run at the same time?

1034

What security is provided with microstrategy desktop?

971

What does microstrategy desktop allow users to do?

910

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

1059

Can I deploy a single bi application in multiple languages?

983

What is the order of precedence of vldb properties?

1011

What specific features and functionality do I get with olap services?

958

What subtotaling features does microstrategy desktop contain?

995

Un-Answered Questions { Data Warehouse }

Define catalog in cognos and write its various types?

1186

What does microstrategy desktop allow users to do?

910

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1112

what is the meaning of upgradation of Repository?

3748

what are the others of "bad files" and "discard files" when using sql*loader?

2137

Which transformation we use to convert 'NA' to 'Not Available'

1271

explain the methodology of Data Warehousing?(Polaries)

2301

What is the project in datastage?

1116

While creating table my dba has fallback or no fallback in his ddl. What is that?

1188

What is substr function?

1197

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1285

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1276

what is the meaning of ending bulk load mode?

Explain a mapping, session, worklet, workflow, mapplet?

1115

How do you import and export the datastage jobs?

1163

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