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

What is EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.

1 13033

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

Polaris,

2731

what is procedure to use mapping variable in source qualifier transformation? with example

IBM,

1 7302

how to create a sample mapping for dynamic lookup transformation

2 5198

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 3309

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2073

What is conditional DML and Structured DML?

Accenture,

2 28118

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

TCS,

1 3792

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

TCS,

2 4318

explain different levels in pushdown optimization with example?

TCS,

2 7306

waht type of interface is used for testing the data in informatica

CTS, TCS,

2260

wat are deployement groups in informatica, how it will be used for developers

1722

what is the difference between informatica6.1 and infomatica7.1

TCS,

2284

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9040

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

CTS,

3 8957

Un-Answered Questions { Data Warehouse }

Describe a data warehouse.

992

differentiate between view and materialized view?

Can we access multiple operational databases from within a single microstrategy project?

1065

Explain Dataware house architecture .how data flow from intial to end?

2588

What are the prerequisite tasks to achieve the session partition?

1258

Target increases every day even though no new record was inserted

1589

is data integration and etl programming is same? : Sas-di

1088

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1296

What are modeling tools available in the market?

980

What is the difference between one to one merge and match merge? Give an example.

1070

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1106

How to sort in descending order?

1263

what is difference between drill & scope of analysis?

1096

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1167

describe about physical data integration? : Sas-di

1048

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