I need some help, Can anyone, tell me how to take snapshot of the particular time period say one week or one month, to compare the table data with the previous week or month's data, and if there any change,then how to find the variance percentage in it.
1. with oracle, SQL&PL/SQL, script
2. with informatica.
I need to implement the solution at both above levels, can anyone help me in this.
Thanks in advance.