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?

10490

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 5847

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 15114

what r the sources u need to create the datastage?

1 6071

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

Wipro,

2 6454

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

Wipro,

2418

what is profile and packages in BOXI??

1 6360

How will u execute a stored procedute from a reportstudio

Cap Gemini,

2 7295

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

Satyam, Tech Mahindra,

1 7624

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 4712

how can we join one oracle & flat files ?

ME,

2 9674

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 7921

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

SAS,

7 13901

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

2605

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 7757

Un-Answered Questions { Data Warehouse }

What is informatica etl tool?

1061

What are the different type of jobs in datastage?

1087

Write the program through which the records can be updated?

1055

What is the difference between group and associare?

1089

What is a partition?

1222

How can you set the client management?

1065

What is the advantage of informatica?

1129

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1073

What are the new features included in the new version of SAS Programming Language?

1251

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1186

how to merge 2 crosstabs thans

2692

what is flow of project?

2061

What is the role of unrestrictive users? : sas-grid-administration

1079

Define the cognos reporting tool?

1109

What is the good sas programming practices for processing large data sets?

1180

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