Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

selecting the week,month, year in source throgh odi 11g?

ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTDJan 20 2016 — edited Jan 20 2016

Hi,

I have 3 years data in a source table(tableatm). data will be added into that table eod.

i have applied filter on the atm_date column as below screen shot

Based on filter, I want to load current year data,current month data,current week data,previous month data, previous week data, previous year data to that table.

If i want to load 2010 data, then filter applied on TO_CHAR(TABLEATM.ATM_DATE,'YYYY')='2010' , i am geting 2010 data only.

if want to load 2015 data, filter applied on TO_CHAR(TABLEATM.ATM_DATE,'YYYY')='2015' .But this is constant..

i want to give filter like this.

TO_CHAR(TABLEATM.ATM_DATE,'YYYY')='(select (sysdate,-12) from dual)'. when i applied filter using this formula on that date column. i am not getting any data.

please help me..

please help me,

Thanks in advance,

A.kavya.

This post has been answered by ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTD on Jan 20 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2016

Added on Jan 20 2016

#business-intelligence-applications, #data-integrator, #filter, #odi, #system-management-and-integration

4 comments

1,287 views