Hi,
Do we need a separate database for each ETL server?. In my project, two schemas are created instead of two ETL servers. Why do we need to have two schemas or databases for two etl server?
Thanks,
Bharathappriyan
Do we need a separate database for each ETL server?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Fri Sep 23, 2005 6:01 pm
-
- Participant
- Posts: 47
- Joined: Fri Sep 23, 2005 6:01 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Best practice is to have one WAS instance and one XMETA database to control as many engines as you have. Or, perhaps, one for production and one for all non-production environments.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.