How is the data for LR generated?
-
SQL query in Hyperion
-
SQL query in Informatica
-
SQL Query on DWH data
-
SQL Query in Datastage
C
Correct answer
Explanation
The 'LR' data is generated by executing SQL queries directly on the Data Warehouse (DWH) data, not through intermediate tools like Hyperion, Informatica, or Datastage. This direct SQL approach on consolidated warehouse data is the standard method for generating such reports.