I WANT TO SYCRONIZE DATA FROM TABLE(MASTER) TO TABLE(DIMENSION);
i.e WHEN TABLE(MASTER) GETS UPDATE/INSERT DATA IN TABLE(DIMENSION) SHOULD ALSO GET UPDATE/INSERT OF DATA. WHAT ARE THE VARIOUS OPTION POSIBLE AND WHICH IS THE BEST?
1. TRIGGER ON TABLE(MASTER);
WHICH WILL TAKE LOT OF TIME, I SUPPOSE.
I DO NOT KNOW THE HOW MUCH TIME IT TAKE.
OR IS THERE ANY OTHER OPTION SO THAT THE PROCESS IN ENTERPRISE MANAGER, IS AUTOMIZED?
Is your question still open?
If so, tell me some more about this case:
- Is this second table equal to the first one or is it totally different with just some fields from the first one?
- Is it important to have the data refreshed online or can you manage using a refreshtime of some minutes?