Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using Enterprise Manager I'm looking to replicate my address table. But only addresses of active persons should be replicated.
Address.PersonId references Person.Id so I suppose that I should use some SQL and then only select addresses whose Person.Active = "true".
In what menu do I apply this filter and what would be its syntax?
Hi,
First, in general, to achieve what you want you should look at the Replicate users guide under:
'Defining transformations for a single table/view':
You will have to first perform source_lookup for the Address.PersonId in the table persson based on the key person.id and get the value of Person.Active and keep it in a column. and then you will be able to define a filter to filter the rows based on the value of the new column you have created that includes the content of Person.Active.
Regards,
Orit
Hi,
First, in general, to achieve what you want you should look at the Replicate users guide under:
'Defining transformations for a single table/view':
You will have to first perform source_lookup for the Address.PersonId in the table persson based on the key person.id and get the value of Person.Active and keep it in a column. and then you will be able to define a filter to filter the rows based on the value of the new column you have created that includes the content of Person.Active.
Regards,
Orit
OK thanks a lot.
Hi @Ole_Dufour
If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!