Skip to Content
0

Data filtering in SLT system

Apr 26, 2017 at 05:18 PM

188

avatar image
Former Member

Hi All,

We have couple of ECC tables replicated to SLT server.

For Ex: if the ECC table has 10 years of data then the same data would be available in SLT along with the new data.

We need only 3 years of data to be replicated.All records before 3 years should not be replicated.I tried to use the filter option using IUUC_REPL_Content.I created a rule assignment using an include program.But when i started the replication the filter did not work.Do i need to maintain any other settings to make the filter work.Kindly advice.

Thanks in Advance.

Regards,

Kumar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Steve Guo
Apr 26, 2017 at 07:01 PM
0

Can you paste the rules you created?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 27, 2017 at 06:07 AM
0

Hi Steve,

Please find the below details.This has been added as a include statement under Rule assignment.

if <wa_s_ce11000>-budat LT '01.01.2015'.
skip_record.
endif.

Also under Advanced replication settings do we need to maintain anything under Table settings/Trigger options and Replication logging.

Regards,

Harish

Show 1 Share
10 |10000 characters needed characters left characters exceeded

try to change the if to

if <wa_s_ce11000>-budat LT '20150101'

0