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?

1157

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

1129

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?

1036

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

1152

What is local and formal parameter?

1402

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

1131

What is the importance of eme in abinitio?

1135

Where $mpjret is used in ab-initio?

1146

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

1184

What is brodcasting and replicate?

1209

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

1098

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

1100

What are differences between different versions of co-op?

1208

Explain difference between onrow and onread method?

915

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?

986

Un-Answered Questions { Data Warehouse }

Can you execute a macro within a macro? Describe. : sas-macro

1111

Explain what is the difference between stop and abort?

1045

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1345

Explain what is data step?

1205

What are the different types of reports present in cognos?

986

What do you mean by drill through report?

968

describe the interaction table in sas di? : Sas-di

1031

please please give me some banking calculations in framework manager.

2087

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1773

What is decode in informatica?

1165

Compare dataset and fileset?

1039

can we perform checkin and checkout through sandbox?

1179

What is a partition and what are the different types of partition components in abinitio?

1273

What are the steps involved in the process flow of the sql statement through channel attached system?

1107

What is an enterprise?

1045

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