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 u will determine the performence tune will occur either in report or system

Ness Technologies,

2147

how u will design the report if the objects are available

Ness Technologies,

2776

What is the difference between nodup and nodupkey options?

iFlex, Makro, Talwar,

20 80120

How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C

Accenture, Oracle,

3 10876

how can you code the confidence intervals?

Cytel, IIT, Ranbaxy,

6 13749

what is report burn and where it occurs

IBM, Target,

3 10552

what is logs in cognos

Target, Thomson Reuters,

1 8679

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 6766

what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

Satyam,

2 7929

what is meant by roll up and roll back in dataware housing????

Covansys, IBM, Wipro,

4 12494

suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

CTS, iFlex,

3 15533

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

Covansys, IBM, Wipro,

1 4883

what r the names of the reports that u prepared???

Covansys, IBM, Wipro,

9 15131

what is the automation tool used for data warehouse testing???

Covansys, IBM, Wipro,

3 10765

in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day

IBM, iFlex, iGate,

2 7410

Un-Answered Questions { Data Warehouse }

What are the different types of mstr objects?

1010

How do you debug and test your SAS programs?

1575

What is the difference between datastage and informatica?

1131

Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

1037

What is the role of co-operating system in abinitio?

1470

What are the steps to create a data model?

1075

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

1353

what is the Default Source Option For Update Strategy Transformation?

1252

What is the use of stop statement?

1095

What are the functionalities of link partitioner?

1035

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2598

whom do you report?

1945

What you mean by drill across?

1037

In informatica workflow manager, how many repositories can be created?

1378

Explain the term 'row' related to relational database management system?

971

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