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

Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash

3 6713

What is the difference between Thin client & thick client?

5 28434

What is value prompt limitations while creating report? What is select and search prompt?

1 10992

what happens if cardinalities are not resolved?

PCS,

3 10047

Can anyone tell me the step by step process how to connect cognos to oracle?

3 7772

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2536

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

2183

how many types transformations supported by sortedinput?

4 8427

what is lookupoverriding?

1 5897

How would you remove a format that has been permanently associated with a variable? ________________

Quintiles, TCS,

5 22163

what is the process of target load planing?

IBM,

2 6662

What is minimum version of internet explorer to run the Cognos report.

3 6746

What is the abrevation of .PPR? (Power play report) or anything new?

1 4326

what is the process we used in joiner transformation,there is no matching column in sources?

2 6885

what is the diff b/w union and joiner and lookup?

4 14661

Un-Answered Questions { Data Warehouse }

Compare aggregates and data marts

2779

How substr function works in sas?

1235

What is a folder? Difference types of stages?

1189

Explain the pipeline partition with real time example?

1155

How do you improve the performance of the Cognos Analytics report

1051

What are the various kinds of the hash file?

1161

What are the types of hierarchies?

1039

what is enterprise guide? What is the use of it? : Sas programming

1032

What are the new features of informatica 9.x developer?

982

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2368

Describe a time when you were really stuck on a problem and how you solved it?

2648

How to update or delete the rows in a target, which do not have key fields?

1192

Explain how we drill up week to month?

1104

How one source columns or rows to be loaded in to two different tables?

1144

On which Dimension Table you implemented SCD Type in your Project

2066

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