ELT and Experience: Difference between pages

From ACT Wiki
(Difference between pages)
Jump to navigationJump to search
imported>Doug Williamson
(Create page. Source - Data Analytics Newsletter - 14 June 2023.)
 
imported>Administrator
(CSV import)
 
Line 1: Line 1:
''Data - databases - data cleansing.''
''Pensions.''  
 
Liability projections require assumptions for a number of variables, including mortality, early leavers, inflation and other factors.  
Abbreviation for Extract, Load, Transform.
 
Actual experience of these variables will cause the liabilities at any point in the future to differ from the projections, which will in turn influence contribution rates and the like.
A process of data handling between systems that first extracts data from the first system and loads it into the second system.
 
Then - within the second system - any necessary transformation of the data is undertaken.


For example, increasing longevity will lead to increased liabilities (and hence to increased contribution rates).


== See also ==
== See also ==
* [[Data]]
* [[Experience gains and losses]]
* [[Data cleansing]]
* [[Stability]]
* [[Database]]
* [[ETL]]
* [[Information technology]]
* [[Transformation]]
* [[Transformational coaching]]
* [[Treasury transformation]]


[[Category:The_business_context]]
[[Category:Identify_and_assess_risks]]
[[Category:Manage_risks]]
[[Category:Risk_frameworks]]
[[Category:Risk_reporting]]
[[Category:Technology]]

Revision as of 14:19, 23 October 2012

Pensions. Liability projections require assumptions for a number of variables, including mortality, early leavers, inflation and other factors.

Actual experience of these variables will cause the liabilities at any point in the future to differ from the projections, which will in turn influence contribution rates and the like.

For example, increasing longevity will lead to increased liabilities (and hence to increased contribution rates).

See also