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 13054

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,

2742

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

IBM,

1 7310

how to create a sample mapping for dynamic lookup transformation

2 5207

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

1 3317

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

2082

What is conditional DML and Structured DML?

Accenture,

2 28140

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 3808

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

TCS,

2 4332

explain different levels in pushdown optimization with example?

TCS,

2 7321

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

CTS, TCS,

2265

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

1733

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

TCS,

2294

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9052

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

CTS,

3 8980

Un-Answered Questions { Data Warehouse }

What is meant by target load plan?

990

What is main advantage datawarehousing over oracle?

1016

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2045

What is the function of Stop statement in a SAS Program?

1163

Explain the data types present in bo n wht happens if we implement view in the designer n report?

993

What is dynamic aggregation in microstrategy?

988

What are different deliverables according to phases?

3417

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1400

What are the different functions included in the server software?

1050

How will I be charged and billed if I use Amazon Redshift?

How can you export a component’s internal parameters ?

2414

What is the command manager?

1012

Compare sas with other data analytics tools.

1044

can u give example for factless fact table

6676

how to perform back drill through in cognos 8 what is the use of it

2559

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