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 9149

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 6362

how many data models u have done in informatica project?

TCS,

2 8298

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

3 7369

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 6485

what is the use of LRECL option.

L&T,

1 9962

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

L&T,

2 8098

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...

2174

Best institute for MS BI training in Hyderabad, India?

4 14422

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 11455

How to change font color of values in hyperlinked columns?

4 7385

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 8632

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 10924

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

2205

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

2239

Un-Answered Questions { Data Warehouse }

How can we use mapping variables in informatica? Where do we use them?

1208

Define Job control?

1153

What is drill down and slicing and dicing whats the difference between them?

1074

What is the function of model design accelerator?

963

What is meant by a Parsing Engine?

1191

Explain difference between data ware house & data mart?

993

explain the concepts and capabilities of business object? : Sas-bi

969

Explain in detail abt measure objects? And what is the use of it? How to create it?

1017

What are the popular informatica products?

1015

Briefly define reusable transformation?

1135

What is a linked cube?

1013

How many Key we can define in remove duplicate stage?

1390

Enterprise data warehouse your projects phase by phase explain?

1930

Does AWS Redshift use SQL?

How one source columns or rows to be loaded in to two different tables?

1131

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