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

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 4303

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

Systime,

1 18244

Hai..,in datastage how to explain project in interview?please explain any domain please.

Wipro,

1 13802

what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?

Accenture, Infosys,

2 9421

How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema ?

1 5515

what is crosstab reporting,slice and dise and drill mode??

3 12680

when we go for unconnected lookup transformation? and why?

Accenture,

5 14719

why we use source qualifier transformation?

Accenture,

16 47073

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

L&T,

4 18227

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

L&T,

8 22858

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

GE,

2 9347

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

IBM,

1 6506

What are the challenges of Dataware housing in the future?

HP,

2 8312

Which gives the more performance when compare to fixed width and delimited file ? and why?

HP,

3 13921

Explain about derived tables?

Cap Gemini,

2 8945

Un-Answered Questions { Data Warehouse }

Mention what is abinitio?

1048

What are cluster analysis in data warehousing?

1183

What are the various kinds of the hash file?

1201

what is information maps?

2283

What is called partitioned primary index (ppi)?

1057

What is the difference between snowflake and star schema?

1101

What is the difference between datawarehousing and businessintelligence?

1145

How to deploy from one server to another server?

2547

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

1473

Enlist the syntax rules followed in sas statements.

1135

How can one identify whether mapping is correct or not without connecting session?

1498

Compare ETL & Manual development?

1004

How to update a particular record in target with out running whole workflow?

1635

What are the functions of a teradata dba?

1131

What are products of cognos?

1028

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