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 6019

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

2 6441

convert yyyy mm dd to dd mm yyyy?

4 16249

how to closeing records after 10,000 records come?

3 6372

how to add a new records into source?

2001

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 8956

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

IBM,

1 4866

how u link universes of same functional domain ?

Business Intelligence Analytics, IBM,

2 5906

How to Rename Library?

3 11318

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

TCS,

3 17767

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 8089

What is snapshot thumbnail

3 5936

difference between impromptu and cognos8

HCL,

2449

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 27372

Un-Answered Questions { Data Warehouse }

How to compare two dmls in abinitio

1835

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1393

How will you monitor the errors received while running i-server and report?

950

what is sas metadata repository? : Sas-bi

1120

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1016

Where the data cube technology is used?

964

What is persistent lookup cache?

1037

Explain fact table?

1059

What do you understand by local lookup?

1164

What are the different forms of output that can be obtained after processing of data?

1256

What is load manager?

1057

Which command using Query Analyzer will give you the version of SQL server and operating system ?

5079

can we perform checkin and checkout through sandbox?

1184

Explain some differences between mpp and smp?

1109

What are the popular informatica products?

1015

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