Skip to Content
0

Extract Real Time Selected Columns data from PA tables for Employee Master data into a table

Oct 03, 2017 at 07:05 AM

30

avatar image
Former Member

Hi Experts,

Need your advice in a scenario where we want to extract Real time Selected Columns data from all PA tables and store it in a table.

As shown below we have SLT replicate enabled for all PA tables and they are used for Reporting via Hana Calculation views.

Additionally we have a requirement to create a table "Employee Master Data" with a sample Structure where data is coming from all the PA tables.

Endda & begda can be ignored for now , but all the other fields latest information has to be replicated on a real-time basis.

The Idea is to capture the change happened on Real Time in any of the PA tables and store the data in a single target table. This Table is required for transmitting data to Other Data bases. All this is required on Real time purposes.

Can you please let us know if we can capture changes in multiple tables using Multiple Triggers to insert/update a single Target Table.

We suggested that we transfer this employee data in batch mode similar to a full load technique in BW. But the requirement is to update the data in real time (from all the tables). Please let us know if anyone has handled a similar situation and have a solution for this issue.

Awaiting all the Valuable Suggestions/Solutions.

Thank you!

Regards,

Arun Kumar

capture.png (43.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers