HI, Actually i had 4 crores of records and i built the SAS DI job for historic run it has taken 10 hours. since its historic it is one time run. The problem is I have to build the job for incremental for daily run. so for daily incremental run i have to pick only the changed records from souce and run the job so that i can do my daily run within 2 hours approximately. so i want to implenent ORACLE CDC TRANSFORMATION after source table. Please help me how to go a head with this transformation step by step. and how to select the options inside CDC Transformation and how to use Control table if it is necessary. Plz try to help me. THANKS IN ADVANCE.
... View more