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?
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 ...
What is the life cycle of Data Warehousing in Real-time?
How to compare values in data table?
View page [1] 2 3 4 5 6 7 Next >>

Go Top