Topic
  • No replies
ravi8679pilla
ravi8679pilla
1 Post

Pinned topic Need Logic >>>>>

‏2011-01-25T08:28:18Z |
1.Data Extraction Rule :-
if the date of the month is less than 10 Then extract the data from last 2 months till date
e.g current date 12/05/2010
Extract data from 1st October 2010 till 5th December 2010
If the date of the month is greater than 10 Then extract the data from last month till date
e.g current date 12/12/2010
Extract data from 1st November 2010 till 12th Decemeber 2010

2.Data Extraction Rule :-
The data should be extracted from the previous quarter of the year for the input date passed.
For e.g
If the input date is 14-Apr-2010 the job should extract Q1 data since the input date falls in Q2.
If the input date is 03-Sep-2010 the job should extract Q2 data since the input date fall in Q3.

3.If the data populate through extraction rule 1 the source identifier is D ELSE Q

4.Input date will be sent as a parameter to the job.

Thanks in advance kindly help me to sort out this