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

How to extract sap data using informatica?

1 1113

Explain what are the various etl tools in the market?

1 1008

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

1 1011

Explain do we need an etl tool? When do we go for the tools in the market?

1 1086

Explain do we need an etl tool?

1 1089

When do we go for the tools in the market?

1 1009

Explain what is etl process? How many steps etl contains explain with example?

1 958

How many steps etl contains explain with example?

1 1049

Explain and compare etl & manual development?

1 987

Explain the difference between etl tool and olap tools?

1 980

What are various etl tools in the market?

1 1095

What task is 98% of the required work of a business analyst?

1 1137

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1176

What is aggregate table and aggregate fact table ... Any examples of both?

1118

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

Un-Answered Questions { Data Warehouse }

How do you remove duplicate records in informatica? And how many ways are there to do it?

1231

Explain scd type 3 through mapping.

1071

explain in detail about type 3?

1083

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

What sort of existing documents should business analysts refer to when starting on a new project?

1078

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1176

what are the data modeling tools you have used?(polaris)

2057

What is aggregate table and aggregate fact table ... Any examples of both?

1118

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2149

Explain how to generate iqd file from framework manager?

1020

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

How to create the source and target database connections in server manager?

1144

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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