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 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 6016

ename like ibm,tcs,hcl need display those records only how?

2 6435

convert yyyy mm dd to dd mm yyyy?

4 16238

how to closeing records after 10,000 records come?

3 6367

how to add a new records into source?

2000

in oracle target stage when we use load option and when we use upsert option?

2285

How To find the location of APT_confid file

CTS,

2 8949

it is possible to link two universes of separate functional domain ?

IBM,

1 4864

how u link universes of same functional domain ?

Business Intelligence Analytics, IBM,

2 5902

How to Rename Library?

3 11312

what is difference between Rich client web intelligence and Boxir2 web intelligence

TCS,

3 17756

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2, Please let me know how can we acheive this in informatica Thanks in advance

4 8080

What is snapshot thumbnail

3 5929

difference between impromptu and cognos8

HCL,

2442

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

Deloitte,

7 27358

Un-Answered Questions { Data Warehouse }

What are the 3 components in sas programming?

1195

What is the work of tranwrd function?

1248

Explain what is the difference between microstrategy and cognos reporting tool?

1074

How many dimensions are there in informatica?

1091

What are the scenarios in which full table scans occurs?

1010

what are the different authentication modes available in microstrategy?

1107

1. Explain your project.

2048

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1131

What is a dimensional model?

981

What are the co> operating system’s assorted library of integrated components?

1119

how we can generate cubes in cognos?

What are the functions involved in shared information architecture?

1073

How many types of sorting methods are available in datastage?

1074

How do I create and delete a cluster in aws redshift?

Name some categories in sas 9? : sas-grid-administration

977

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