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 use sorter transformation in joins?

IBM,

5 18196

Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

1 4432

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415

What are symbol tables?Differemce between Local N Global Symbol tables.....

TCS,

2 10562

In which format does Date stores in sas..? What is the use of DATE in SAS.?

TCS,

3 9724

One way of creating a new variable in Macros is by % Let....What is the other way..?

TCS,

5 11140

What are the functions done while Compilation...?

TCS,

1 6406

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

TCS,

3 9316

What is difference between Global n Local Macro Variables..?

TCS,

6 28280

What is Transaction...? And what are Comment, Roll back n Save point..?

2 7068

Explain the Difference Between Bursting and Scheduling?

1 18023

any body can say about all versions of informatica ?how many versions ?

2 10093

if ename='subbu' while running job the job should be abort how come?

IBM,

3 8859

how to find diff between 2 dates without using Icon... funtions?

1 3749

how to find no.of records in sequntial file itself?

4 21864

Un-Answered Questions { Data Warehouse }

Explain the term 'tables' related to relational database management system?

1109

Highlight a few of the important components of Teradata?

1090

What is meant by metadata in context of a data warehouse and how it is important?

1280

Explain which columns go to the fact table and which columns go the dimension table?

972

How can you create a macro variable with in data step? : sas-macro

1095

What is Cognos script editor?

2623

What is a Folder?

1246

How to read an input file in sas?

1200

Have you ever encountered an error called “depth not equal”?

1230

What are cubes and olap cubes?

1049

define tm1 package connector?

List any five applications of data warehouse.

991

When tpump is used instead of multiload?

1150

Explain fact table?

1107

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4160

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