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 to a create header dynamically in a crosstab report in cognos 8.1?

2486

How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.

1 13495

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

IBM,

1 12249

Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara

55 72102

in aggregator , how can i get the sum in readable format

IBM,

4 10352

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

CTS, Wipro,

3 13821

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 25303

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2293

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

IBM,

4 10851

what is performance tunning in BO in report level& designer level?

IBM,

1 6380

How can you join flat file, oracle as a sources?

IBM,

4 13030

1. Explain your project.

IBM,

2098

2. What functional area you worked on.

IBM,

2407

3. What was the size of your cube?

IBM,

1 4243

4. How many dimensions did you use in your reports?

IBM,

2000

Un-Answered Questions { Data Warehouse }

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2193

Explain the definition of normalized and denormalized view?

946

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2683

Name the types of report?

1013

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1195

What is the difference between an operational datastage and a data warehouse?

1215

What is MPP in Redshift ?

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2230

What is the working process for application.cfm?

1086

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7507

What are the processing stages?

1153

What are connected or unconnected transformations?

1176

What is datastage engine?

1225

What are the uses of client software involved in teradata?

1039

I have a few records just I want to store data in to targets cycling way how?

2420

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