How to remove a particular attribute from table using the information gain concept?
What is the merge dimension?
What are the SCD types and what are its Usage?
Latest Answer: SCD - Slowly Changing Dimensions. SCD usages in data warehouse are to store the history of transactions on dimensions. There are three types SCDs:
Type1 - Just rewrite the record if there is a change in the existing dimension record,Type2 -
Keep the ...
What is a use of ROLLUP and CUBE in ORACLE? How do they help Data Warehousing applications?
What is the Reconcialation Process?
Latest Answer: Reconcilation process is a systematic comparision between the data in Dataware house and data in source system.The comparision may be a set a predefined summary values or detailed data periodically. ...
What is Load Frequency and Load Window in ETL?
Latest Answer: ETL Load frequency is how often the ETL processes (that load data into the data warehouse) are run.Load Window is the time allocated for ETL load to execute.e.g. If the load is run daily, and the time allowed for execution is 8 hours then:ETL load frequency ...
How to partition a cube in analysis services?
What is meant by mimic diagram? Where it is used?
How can we schedule our jobs in third party tool - AutoSys?
Latest Answer: Autosys is a total job scheduling solution that allows you to define the event dependencies, time schedules alerts etc making it a complete data center automation tool. An AutoSys job is any single command, executable script, or Windows batch file. Each ...
What is the difference between replicate and broadcast ?
Latest Answer: Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usually done by the dbms itself. Broadcasting usually ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
