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

2.How do you drill through report from Report Studio to Analysis studio?

3 9288

data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?

3 6508

how many data models u have done in informatica project?

TCS,

2 8395

how to get the all values from a prompt using 'ALL' use and display value in prompt

3 7519

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

ABC,

1 6577

what is the use of LRECL option.

L&T,

1 10049

Where do the database management systems store data and how do u import them.

L&T,

2 8225

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2228

Best institute for MS BI training in Hyderabad, India?

4 14563

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 11632

How to change font color of values in hyperlinked columns?

4 7542

How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

1 8714

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

TCS,

6 11124

what do u do when DB time takes more?in sap bi

2248

what is the use of structures?how many nodes can u create in a structure?

2295

Un-Answered Questions { Data Warehouse }

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

2293

What are materialized views & where do we use them?

1081

How to Remove Duplicate using SQL?

1429

What are various types of gateways in cognos?

1137

What is fact degradation?

1025

What is mapplet in informatica?

1134

Explain clustering algorithm?

2336

Did u used latest transformations of 8.6.0? for what?

1933

Explain me what is vldb?

982

How to create context?

1067

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1217

what is size of u r database?

2367

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10729

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

972

What is a look-up?

1357

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