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 am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1 1226

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1 1200

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1 1110

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1 1206

What is local and formal parameter?

1 1472

Why might you create a stored procedure with the with recompile option?

1 1202

What is the importance of eme in abinitio?

1 1209

Where $mpjret is used in ab-initio?

1 1211

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1 1257

What is brodcasting and replicate?

1 1263

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1 1158

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1 1159

What are differences between different versions of co-op?

1 1296

Explain difference between onrow and onread method?

1 959

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

1 1051

Un-Answered Questions { Data Warehouse }

How to create the source and target database connections in server manager?

1140

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2102

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1233

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

2161

What is the purpose of Dataware Control?

1113

Explain in detail about scd type 1 through mapping.

1644

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1033

What is dimensional table? Explain the different dimensions.

1265

What is node? How many nodes and amps used in your previous project?

1169

Explain scd type 3 through mapping.

1068

draw informatica architecture 8.6 ?

3939

faq's on cognos

4112

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

842

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3650

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2171

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