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 can we migrate from Businees Objects reports to Cognos 8.x??

1 5577

8. How much supervision have you typically received in your previous job?

CST,

2255

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

Banking, Genpact, TCS,

4715

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

Wipro,

3 13491

hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.

WNS,

2 7107

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

CSC,

3 8352

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

CSC,

10 34516

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 7660

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 18758

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 6581

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5646

Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

IBM,

7 16370

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

WNS,

2 6998

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 7773

use scheduler to refresh report.....explain please.....

2 5377

Un-Answered Questions { Data Warehouse }

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1007

Explain how a source file is populated?

1366

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1035

What is size of a transaction and an array means in a datastage?

1313

How to calculate fact table granularity?

1020

What do you know about sas and what we do? : sas-grid-administration

1145

how would u estimate the size of Aggregator transform data and index cache?

2413

What is a compound attribute in microstrategy?

1037

Differentiate between hash file and sequential file?

1072

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1954

What would be the next step after collecting the data?

1191

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1372

What is a standalone command task?

1204

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2230

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1909

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