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 7830

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

IBM,

2 4862

What is RCP

CGI, CTS,

5 21828

How can we achive parallelism

CTS,

1 7869

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

IBM,

4 8585

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

IBM,

3 8674

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

Satyam, TCS,

1 4994

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 5059

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 36248

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

CTS,

1 7224

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 9206

example for generated prompt

1 4609

What is Data Vault???

2757

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 7460

what is dynamic sort?

Infosys,

1 6218

Un-Answered Questions { Data Warehouse }

what is operational data and operational system? : Sas-di

1125

Tell me what is full load & incremental or refresh load?

959

What is workflow manager?

1062

what is the difference between nodup and nodupkey options? : Sas programming

1208

what is SAS OPTIMIZATION?

2312

What is MODEL is Data mining world?

2627

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1004

What is the command used to find missing values?

1113

how to load the data to fact table?

2717

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1017

How to convert RGB Value to Hexadecimal values in datastage?

4013

sed,awk,head

1472

What are the main features of datastage?

1296

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2082

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1788

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