Implementing SCD using SCD stage or Change Capture. RCP and Multiple instance jobs. Handling partitioned databases. Bulk loads Parameter sets.
Improvements to My Organization
Reduces the loading and development time for Datawarehouse ETL. Makes it easy for coding Complex business rules.
Room for Improvement
Better Index handling in connector stage with different loading patterns. Heavy use of scratch disk which sometimes leads to failure.
Use of Solution
I have seen issues with an Enterprise stage to connector stage migration
The only issue I have seen is job locks (It depends on the internet speed).
Customer Service and Technical Support
Customer Service: It is excellent.Technical Support: It is excellent.
We implemented it in house.