SQL Replication to InfoSphere DataStage tutorial
Learn how to integrate SQL Replication and InfoSphere® DataStage® to provide a real-time data feed that you can use to create dynamic data warehouses.
Learning objectives
After you complete this tutorial, you will know how to:- Set up SQL Replication between two DB2® databases by using ASNCLP command scripts
- Use the ASNCLP program to generate DataStage definition files for creating DataStage jobs
- Create a DataStage project and data connection
- Import table definitions from DB2 into DataStage
- Compile and run a DataStage job
- Browse the contents of a data set to verify end-to-end integration