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,

2149

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 80129

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 13751

what is report burn and where it occurs

IBM, Target,

3 10556

what is logs in cognos

Target, Thomson Reuters,

1 8681

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 7933

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

Covansys, IBM, Wipro,

4 12499

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

CTS, iFlex,

3 15535

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

Covansys, IBM, Wipro,

1 4885

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

Covansys, IBM, Wipro,

9 15136

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

Covansys, IBM, Wipro,

3 10767

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

IBM, iFlex, iGate,

2 7412

Un-Answered Questions { Data Warehouse }

What is the command in bteq to check for session settings ?

1194

Can we get 1st record through Informatica(without sequence number).

1494

Demonstrate experience in maintaining quality process standards?

2572

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1964

what is pmrep command?

2445

To what type of programms have you used scratch macros?

2578

How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

806

The methods to improve performance of a graph?

1090

What is data caches/ index caches?

1116

Explain difference between powerplay transformer and power play reports?

969

How to run a query in teradata?

1102

What is the surrogate key?

1282

What does command task mean?

1164

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3474

What is the purpose of using case expression in teradata?

1037

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