Answer / Sanjeev Aherwar

{"snapshots": "A snapshot in the context of ETL (Extract, Transform, Load) is a point-in-time representation of data. It is created by taking a copy of data from a source system at a specific moment. The purpose is to capture a consistent view of data for reporting or analytical purposes.","materialized views": "Materialized views in Oracle ETL are pre-built, optimized query results that reside in the database. They are used to improve query performance by reducing the time taken to execute complex queries repeatedly. Materialized views are particularly useful when dealing with large datasets and complex join operations. The data is refreshed periodically based on a schedule or manually.","materialized view definition": "A materialized view definition (MVD) in Oracle ETL is a SQL statement that creates a materialized view. It includes the SELECT statement, any joins, filters, or sorting criteria needed to produce the desired result set, and specifies how often the data should be refreshed."

Where do we use connected and un connected lookups?

1 Answers  

---

What are active transformation / passive transformations?

1 Answers  

---

How to determine what records to extract?

1 Answers  

---

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

1 Answers  

---

What are materialized views & where do we use them? What is a materialized view log?

1 Answers  

---

How do you analyze the tables

1 Answers  

---

What are the various tools? - Name a few?

1 Answers  

---

What is a staging area? Do we need it?

1 Answers  

---

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1 Answers  

---

When do you analyze the tables?

1 Answers  

---

What are materialized views & where do we use them? What is a materialized view?

1 Answers  

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

1 Answers  

---