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

any difference between cognos and real time cognos

2206

Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 5807

what is use of fload loading into set table?

IBM,

2 6442

what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

IBM,

2 11711

which option is used to restart the fast load script?

2 7156

what are the file sizes in your project?

2 5917

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2110

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

IBM,

3 7980

If table have access lock.In the same table write lock is posible or not?

1 5405

teradata support to automatically increase the character length or not?

1 5353

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

Wipro,

4 8521

Why should we use star schema in datawarehouse design?

Wipro,

2 6086

What is the difference between informatica 8.x and 9.x

Wipro,

1 12859

How to relege locks in fastload and multiload? example?

IBM,

4 23007

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 4936

Un-Answered Questions { Data Warehouse }

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1047

What are the issues you have faced in your project? How did you overcome those issues?

2365

Is multi insert ansi standard?

2206

How will you create report from two subject areas

833

Is it possible to use a client with different version than that of its Informatica server?

1141

in sap bi we have wad, then why we go for sap bo

3381

what do you mean by data staging area? : Sas-di

1142

What is embedded metric?

990

what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

1092

Explain why should you put your data warehouse on a different system than your oltp system?

923

What is the metric store database?

969

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2336

what is the difference between cardinality and Nullability?

2943

Explain how to export mappings to the production environment?

977

1. Explain your project.

2047

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