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 production issues in datastage?

10423

I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh

2 5742

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

CTS,

1 15026

what r the sources u need to create the datastage?

1 5999

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

Wipro,

2 6371

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

Wipro,

2376

what is profile and packages in BOXI??

1 6284

How will u execute a stored procedute from a reportstudio

Cap Gemini,

2 7208

How can we change any header or footer for a group of reports

Satyam, Tech Mahindra,

1 7547

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 4638

how can we join one oracle & flat files ?

ME,

2 9557

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

iGate,

2 7823

What are the joins,types of joins and thier functions?

SAS,

7 13709

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2556

Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

iGate,

3 7612

Un-Answered Questions { Data Warehouse }

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

3461

Explain what is SAS informats?

1098

Can you define set to be cardinality?

1016

ware house management system is used?

1018

how will you locate the sas platform applications? : Sas-bi

1035

How to select multiple values from type-in prompt?

1062

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1024

Why do you get spool space errors? How do trouble-shoot them?

1060

What is partitioning? What are the types of partitioning?

1172

define snapshot?

What is the multi-insert?

1037

What is the role of sas grid administrator? : sas-grid-administration

1291

Differentiate between a database and data warehouse?

1148

What are diagrams?

1046

How would you identify a macro variable? : sas-macro

1026

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