Data Warehousing Interview Questions 

Hello and goo day! Help would be much appreciated!

A scenario from one of my data warehousing classes...

A client is in need of a database for his sales web app

and the client is stuck between choosing Microsoft SQL Server or MySQL

which database do you think should the client choose? and why should he choose that database...

Thanks a lot people!!!

i have experience in .NET , java , oracle , sql pogramming . i will work for experience . iam interested in data warehousing also and learning abt it , i would be very thankful if someone offers me an oppurtunity to work for them for free . thank you

I have 2 yrs experience with SQL and PL/SQL. I'm planning to do Data warehousing course.
Is choosing data warehousing right for me(with the experience that I have)?
Or is it better to do Oracle application developer course?

1) Can anybody suggest me good training centers in Chennai?
2) Does anybody know about infitech in chennai and Sqlstar
in chennai?
Thanks.

I am trying to figure out the simplest way to count the # of times a user ID appears in a column. FYI the user ID is defined as char not numeric

I have a query that tells me what users are accessing tables in our data warehouse directly rather than via the table view which violates our policy for queries run in production and I see the same user ID many times. My problem is that this query returns 700 rows so that is way to many to sift through manually. I need to narrow it down so that I only see each user once and how many times their ID appeared in the column.

I've been given a schema for an OLTP SQL database from which I've to make the Star Schemat. I'm confused at extracting the Dimension tables, specially "Time Dimension". The Fact table has to be "Inventory_Fact".
Requirements are:
1.Name or Ids of suppliers whose orders are delayed and those whose orders are delivered in time
2.Avg. delay in number of days in shipment of orders by the company to the customer
3.Avg discards in orders by the customer
4.Avg. discards in orders supplied by the supplier to the company
5.No. of units currently in stock
6.Tot no. of orders ordered by customers against a certain time period
7.Tot. sale made by the company in a given time period against one or more products
8.Tot no. of orders placed by customers to the company
9.Which product is sold in certain region in certain time period?
10.Tot. prods ordered to company by customers
11.Tot. cost of products after shipment.
12.Profit or money gained against certain orders in specific time period

I am a beginner in the world of software with about 1 year exp. I have enough to start with in .NET and SQL Server, almost equal in both.

1. Can anyone who is already in those fields tell me which way to go (and why)

2. If money is my criteria, thaen which route to take?

3. Which of the above two will be more interesting if a long career is the criteria.

Thank you in advance.

I've got 10 years medium complexity database development on Oracle and SQL Server. Most of this development has been in BI/Data Warehouse enviroment. Much has been coporate IT some as an outward facing service provider. I feel I need to be certified help increase my technical profile and make sure it is on par with my business facing profile. Do I need to be certified. How should I go about it?

Hello. I am an IT professional and looking for sample resumes in the field of data warehousing, ETL Developer, BI developer, SQL Developer, data analyst and business analyst. Please help me as I need to update my resume and if you could provide some good websites where I can apply for jobs. I have 2 years of work exp and a MS degree holder.

From Licensing and procurement point of view.
As we are looking at buying the software from Data Warehouse implementation point of view

Hi all,
I am looking for a job in Data warehousing/BI field. I want to know are there very less job in this field in USA?? I searched sm jobsearch sites (dice, indeed) for "data warehouse", "Java", ".Net" jobs and the no of jobs available were actually in this order DW<.Net<java.I have experience in working with Sql server 2005 database and have been learning SSAS, SSIS, SSRS myself. will i be able to find enough jobs in sql server datawarehouse? can somebody plz tell me sm gud sites for searching DW/BI jobs in USA? Also is it true that people of 2-3 yrs of experience are not considered for DW jobs and atleast showing 5-6 yrs of exp would be able to fetch me interview calls?? is there any good DW training institute (inexpensive) in NYC/jersey city area?Please help me!! TIA

I have 2 yrs experience with SQL and PL/SQL. I'm planning to do Data warehousing course.
Is choosing data warehousing right for me(with the experience that I have)?
Or is it better to do Oracle application developer course?

1) Can anybody suggest me good training centers in Chennai?
2) Does anybody know about infitech in chennai and Sqlstar
in chennai?
Thanks.

I want to learn SQL and Data Ware House Tools like COGNOS, INFORMATICA by practising projects which are already done by somebody. I want to know in which sites will I get these type of stuff.