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

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

IBM, TCS,

3 8800

What is target update override

CTS,

2 7553

How to get part of string form the source string without using sub string function in SAS?

3 7820

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 5019

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

Satyam,

2 5967

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

HCL,

5 13165

sorce is a flatfile only 1st and last row should insert to target how will u do?

HCL,

2 9095

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

HCL, Schneider,

2 12445

if soource is having 10 records how will u insert 20 records to target

HCL,

6 12280

In session log thier should not be a single error how will u do

HCL,

3 9126

What is an incremental loading? in which situations we will use incremental loading

HCL,

2 9294

what is diff between IN and EXIT commands

HCL, Schneider,

1 7177

what is persistant cache in which situation we will use persistantcache

HCL,

1 6857

Insert else update option in which situation we will use

HCL,

4 11352

what is pre and post sql and what is diff between source presql and target pre sql

HCL, IBM,

1 19519

Un-Answered Questions { Data Warehouse }

What is option by which we can run all the sessions in a batch simultaneously?

1144

What is datastage?

1083

how do you create schema objects in 2 tier connection?

953

How can users design dashboards quickly and without programming experience or training?

959

What are the different layers in the information server architecture?

1124

What do think which one is the better joiner or look up?

1203

What are the different types of security you have worked in obiee?

789

how would you create multiple observations from a single observation? : Sas programming

1007

What function should we use to display the value entered or selected by a user in response to a prompt?

989

What are the types of containers?

1237

Name any two sas spawners? : sas-grid-administration

1039

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2104

table actions available in oracle connector?

1612

How would you invoke a macro? : sas-macro

1122

Enlist the various types of transformations.

1057

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