ODI Full Load Vs Incremental Load
970475Nov 27 2012 — edited Nov 27 2012Hi,
I am absolutely new to ODI and here in our environments, the development is done in such a way that we need to do the full load everytime when we add a new table in our MIS schema or we add new columns in MIS tables. The whole ODI structure is built in such a way that whenever we make any table structure changes and give the build as Work_Repo.zip file, after the deployment and regenarating the scenarios, a full load is required to be executed to populate newly added tables and columns.
And since the full load takes a very long time to get completed, it really affects the business, so our major concern is to avoid this full load. We have our staging schema different than our source and destination schemas. Which means, we have three schemas: source, staging and target schemas.
My question is, is there any way to avoid this full load after every deployment? If yes, then how can we do that? I have a very less knowledge of ODI till now, please advice me some solution for this. The ODI version is 10.1.3.6.2.
Your help is highly appreciated.
Thanks.