Persisted Stage tables for eBS sources
Hi Experts,
I am currently working on HR analytics and use the OOB Informatica mappings for OLAP data loads. The source is Oracle eBS (HRMS).
I find that there are many PersistedStage mappings to load Persistent stage tables like W_ORA_WEVT_PERF_PS, W_ORA_WEVT_SAL_PS etc. These tables in turn populate _FS tables ( as usual for data warehousing loads).
Can anyone help me in understanding why is this kind stage tables are used even when we have typical stage tables (*_FS) also?
Any document link will also be helpful for my quick reference.
Thanks in advance.
Anamika