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 are the transformations that restricts the partitioning of sessions?

1 9075

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 43724

What is power center repository?

1 11892

How can u work with remote database in informatica?did you work directly by using remote connections?

2 8843

What are the new features in Informatica 5.0?

1 4898

what is incremantal aggregation?

1 6129

What are the scheduling options to run a sesion?

2 11619

What is difference between stored procedure transformation and external procedure transformation?

2 14561

Explain about Recovering sessions?

1 6194

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 19091

How to recover the standalone session?

2 7259

How can you recover the session in sequential batches?

1 9804

How can you complete unrcoverable sessions?

1 5593

What are the circumstances that infromatica server results an unreciverable session?

1 5327

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 7926

Un-Answered Questions { Data Warehouse }

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2360

What is grain of fact?

1029

Tell me more about the parameters in macro? : sas-macro

1099

What is the meaning of decode in informatica?

1167

What is the method of removing duplicates, without the remove duplicate stage?

1084

How is the teradata different from oracle?

1168

What is the difference between the public object&schema object?

1141

How to load specific no.of records using bteq, or fastload,or multiload

1816

What is dtm?

1220

Which commands are used to import and export the datastage jobs?

1468

What is Cognos script editor?

4295

Describe the function and utility of the most difficult SAS macro that you have written?

2630

How can I test reports in cagonos?

1018

how to load dimension table and fact table. plz tell me the steps.

2149

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1109

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