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 differences between proc report and proc tabulate?

3 20961

is there any differnce between proc means and proc summary?

5 9438

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 8503

1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?

IBM,

2 6727

What is Dynamic Grouping? what is diff between grouping n levelspan?

CybAge,

2 9348

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2246

What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

Cognizant, Niteo, SacSoft,

1 5481

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

AIG, Niteo,

1 6707

how to join the two flatfiles using the joiner t/r if there is no matching port?

Cegedim,

5 13661

What is the difference between Conditional Layout and Conditional Block

TCS,

1 11264

What is the diff between Drill through reports and Master detail reports?

CSC, TCS,

2 9415

1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.

1 5157

what are the complex reports you have created. Tell me with example?

Insurance, TCS,

7 33568

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 7148

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 7731

Un-Answered Questions { Data Warehouse }

Explain different types of partitioning?

1050

What is defined as partial backup?

1091

how does sas handle missing values in procs? : Sas programming

1273

What is the difference between router and filter?

1286

What are the various reporting tools in the market?

1084

Highlight a few of the advantages that ETL tools have over Teradata.

1100

what is the limit of string length in turbo integrator?

What is a local lookup?

1234

What are all the types of indexes in Cognos?

1247

What are all the advantages of Cognos?

1047

What is a joiner transformation?

1006

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2012

how can you import .csv file in to sas? : Sas programming

1114

What are query items?

1033

what is treatment emergent events and treatment emregent adverse event

2412

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