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 21162

is there any differnce between proc means and proc summary?

5 9605

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 8568

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 6833

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

CybAge,

2 9455

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

1 2290

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

Cognizant, Niteo, SacSoft,

1 5553

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

AIG, Niteo,

1 6775

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

Cegedim,

5 13827

What is the difference between Conditional Layout and Conditional Block

TCS,

1 11343

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

CSC, TCS,

2 9516

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 5214

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

Insurance, TCS,

7 33827

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

2 7246

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 7841

Un-Answered Questions { Data Warehouse }

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2814

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1095

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

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

2415

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8275

What is the difference between business requirement document and use case document.

1073

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3439

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2253

Explain how to generate iqd file from framework manager?

1010

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

Hi friends, what are the new features in abinito3.0?

2855

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1168

What are the data types present in bo? What happens if we implement view in the designer and report?

1076

draw informatica architecture 8.6 ?

3939

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