Hi All,
I have a requirement to join two ( and sometime - more ) tables before data is sent to target. I need to do this because the field on which filter needs to be applied exist in the master table. So I need to join detail table to master table to apply the required filter.
Example suppose in scott schema rather than migration all the records I want to migrate records of only SALES department.
So I tried to use SQLEXEC in the extract parameter file as follows.
----TABLE dbo.emp ;
TABLE dbo.emp &
SQLEXEC (ID empQuery, &
QUERY "select * from dbo.emp,dbo.dept where dept.deptno = emp.deptno and dept.DNAME = 'SALES'");
However I believe after this I need to take each field of emp table in a token and use this token in replicat.
Is there a way I can replace the select * from emp to my select without have to go token way. As in my case - I am having multiple tables with lot of fields and this process seems to be very cumbersome.
Please let me know if you any trick.
Thanks,
Vibha