Interested to Buy Any Domain ? << Click Here >> for more details...
How does data mining and data warehousing work together?
- 2 Answers
- 15014 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
data warehousing is used to store the historical data.by
using dwh bsiness users can analize thier business.
data mining is used to predict the future.dwh will act as
the source for the data mining
| Is This Answer Correct ? | 17 Yes | 2 No |
Answer / mallika
Datawarehousing is the process of extracting data from
sources,transforming it into required form and then loading
it into the dwh.Simply its a process of converting data
into information.
DataMining is the process of extracting useful information
from large amounts of data for identifying business
intelligent methods.
We extract data from dwh for identifying business
intelligent methods.
| Is This Answer Correct ? | 18 Yes | 3 No |
What are the advantages and disadvantages of reporting directly against the database?
What is execution plan?
I know of using applysimple, but there are other ways too?
Can you pass sql queries in filter transformation?
What are data modeling and data mining? Where it will be used?
How to eliminate duplicate rows from flat file?
How to pivot row data using informatica?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is scd1 , scd2 , scd3?
What is a source qualifier?
Teradata 
