Name some of modeling tools available in the Market? - These tools are used for Data/dimension modeling 1. Oracle Designer 2. ERWin (Entity Relationship for windows) 3. Informatica (Cubes/Dimensions) 4. Embarcadero 5. Power Designer Sybase - Data Warehousing Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

DETAILS

Question: Name some of modeling tools available in the Market?

Answer: These tools are used for Data/dimension modeling

1. Oracle Designer
2. ERWin (Entity Relationship for windows)
3. Informatica (Cubes/Dimensions)
4. Embarcadero
5. Power Designer Sybase

Category	Data Warehousing Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8981 users
Added on	8/24/2014
Views	68570
Rate it!

Question: Name some of modeling tools available in the Market?

Answer:

These tools are used for Data/dimension modeling

1. Oracle Designer
2. ERWin (Entity Relationship for windows)
3. Informatica (Cubes/Dimensions)
4. Embarcadero
5. Power Designer Sybase Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is a general purpose scheduling tool?	View Answer
	What type of Indexing mechanism do we need to use for a typical data warehouse?	View Answer
	What are non-additive facts?	View Answer
	What is conformed fact?	View Answer
	What are the Different methods of loading Dimension tables?	View Answer
	What are conformed dimensions?	View Answer
	What are the various Reporting tools in the Market?	View Answer
	Why are OLTP database designs not generally a good idea for a Data Warehouse?	View Answer
	What is SCD1 , SCD2 , SCD3?	View Answer
	What does level of Granularity of a fact table signify?	View Answer
	What is ETL?	View Answer
	Why is Data Modeling Important?	View Answer
	Why should you put your data warehouse on a different system than your OLTP system?	View Answer
	What is ODS?	View Answer
	If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?	View Answer
	Is it correct/feasible develop a Data Mart using an ODS?	View Answer
	How are the Dimension tables designed?	View Answer
	What is a CUBE in data warehousing concept?	View Answer
	What is a look up table?	View Answer
	What is Data warehousing Hierarchy?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Data Warehousing Interview Questions & Answers - Exam Mode / Learning Mode