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

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 7812

In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?

IBM,

2 4852

What is RCP

CGI, CTS,

5 21818

How can we achive parallelism

CTS,

1 7861

How to hide value prompt box and list when run report?

IBM,

4 8580

How to select all in value prompt instead of cascade prompt?

IBM,

3 8664

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

Satyam, TCS,

1 4989

im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

IBM,

1 5054

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

CTS,

5 36227

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

CTS,

1 7219

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 9200

example for generated prompt

1 4606

What is Data Vault???

2755

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

TCS,

2 7452

what is dynamic sort?

Infosys,

1 6209

Un-Answered Questions { Data Warehouse }

why is a stop statement needed for the point=option on a set statement? : Sas programming

1092

How will you generate test data with no input data?

1183

If your client wanted to customize the null value, how would you do that?

1009

Whether dimension table can have numeric value?

1162

What is an expression transformation?

1028

explain the environment varaibles with example?

1089

Explain teradata architecture in detail with a diagram.

1123

Describe the ways in which you can create macro variables?

1202

If RDBMS is halted what will you do ?

2177

what is business intelligence? : Sas-bi

1073

What is the deployment requirements used in cognos?

1663

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1171

Tell me what is degree of a relation?

1002

When we should use 'jobid' for commit table (Output table component??

9114

What is the main difference between inmon and kimball philosophies of data warehousing?

1121

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