Finding Terasync table database
Posted: Mon Sep 18, 2006 2:50 am
Hi,
There have been several posts realted to fixing Terasync table error which have been useful but I need to find where this table is being created. (as it gets dropped after the job is finished)
I have created following env variables in my DS project Administrator.
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
I have intentionally given APT_TERA_SYNC_DATABASE name wrong (I have no access to create table in this database). But the job is not failing with Terasync table error. That means the parameter values are not what I have defined at PROJECT level and they are no being used. How do I find out where the terasync table is being created.
NOTE that the source teradata table domain is also not the terasync table domain because I do not have create table access to that domain.
Any feedback is appreciated.
Regards,
Vipin
There have been several posts realted to fixing Terasync table error which have been useful but I need to find where this table is being created. (as it gets dropped after the job is finished)
I have created following env variables in my DS project Administrator.
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
APT_TERA_SYNC_DATABASE = [db name for terasync table]
APT_TERA_SYNC_USER = [user name used for terasync table]
APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table]
I have intentionally given APT_TERA_SYNC_DATABASE name wrong (I have no access to create table in this database). But the job is not failing with Terasync table error. That means the parameter values are not what I have defined at PROJECT level and they are no being used. How do I find out where the terasync table is being created.
NOTE that the source teradata table domain is also not the terasync table domain because I do not have create table access to that domain.
Any feedback is appreciated.
Regards,
Vipin