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 21161

is there any differnce between proc means and proc summary?

5 9601

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 6831

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 5552

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

AIG, Niteo,

1 6774

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 33824

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

2 7243

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 7839

Un-Answered Questions { Data Warehouse }

Hi, If anyone has base SAS certification dumps, please share.

1932

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1993

How do you remove duplicate records in informatica? And how many ways are there to do it?

1224

Have you have ever worked in unix environment and why it is useful in datastage?

1210

what are the dimensions that you have in your current project?list them?

2085

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2201

faq's on cognos

4108

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2054

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081

Write the unconnected lookup syntax and how to return more than one column.

1164

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

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

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