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 5502

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

CST,

2207

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

Banking, Genpact, TCS,

4677

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

Wipro,

3 13336

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 7012

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 8169

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

CSC,

10 34171

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

5 7467

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

7 18403

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 6435

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5575

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

IBM,

7 16095

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

WNS,

2 6861

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 7626

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

2 5242

Un-Answered Questions { Data Warehouse }

How to design file watch jobs?

930

What is deployment group?

1136

What is meant by Teradata Gateway?

1011

What are tpump utility limitations?

1066

What is the report studio?

981

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

902

What are the different methods ot loading a dimension table? A fact table etc?

980

Can you explain the co>operating system’s processing model?

1050

What is difference between informatica power mart and power center?

949

what is the cube size?

How to identify ppi columns?

1105

Explain what are the advantages data mining over traditional approaches?

1087

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3561

What are Aggregate tables?

1105

What are the default statistics that proc means produce?

974

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