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?

2441

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

1 13418

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 12170

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

55 70418

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

IBM,

4 10205

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 13678

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 25135

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

2246

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 10714

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

IBM,

1 6301

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

IBM,

4 12894

1. Explain your project.

IBM,

2048

2. What functional area you worked on.

IBM,

2355

3. What was the size of your cube?

IBM,

1 4156

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

IBM,

1954

Un-Answered Questions { Data Warehouse }

how do u extract data from different data sources explain with an example?

2245

Where is tm1 web logging information found?

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2385

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2396

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

Explain what is the metadata extension?

1038

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1925

Explain the difference between the truncate and delete commands?

1167

Define datastores in cognos?

953

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1063

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1955

What are the differences between sql override and update override?

1101

what is degenerated dimension?

3998

What are session timeout and application timeout?

1022

Explain me what are data marts?

1049

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