Warning while using Teradata Connector -RCP enabled

ray.wurlod · Post by **ray.wurlod** » Thu Dec 30, 2010 3:53 pm

Do you have a particular need to have RCP enabled?

srai · Post by **srai** » Fri Dec 31, 2010 12:26 am

ray.wurlod wrote:Do you have a particular need to have RCP enabled? ...

Actully our parallel job is a generic job, where at run time we just passing source and target table name from parameter. We are not loading the source and target metedata in the JOB.

If I do not enable RCP, we need to load metedata for each conbination of source and target. In that case we need to have 30 jobs to load 30 tables.

I am not sure if this can be acheived without enabling RCP in one job.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 31, 2010 3:31 am

Any transformation must have the column(s) to which it applies present on the Transformer stage input link - it must be there explicitly, it cannot be provided via RCP. So, unless this transformation exists for all of your generic possibilities, it looks to me like you're going to need more than one "generic" job.

srai · Post by **srai** » Mon Jan 03, 2011 12:46 am

ray.wurlod wrote:Any transformation must have the column(s) to which it applies present on the Transformer stage input link - it must be there explicitly, it cannot be provided via RCP. So, unless this transformation ...

.

Hi Ray,

You are correct. I have mentioned that coulmn (Job_EXECUTION_ID) explicity in the transformer and value is getting gererated at run time. It is not coming via RCP.
But other columns are provided via RCP.
JOB_EXECUTION_ID is common column in all the tables. But the values is being passed at run time that is why we are using transformer.

If I use copy stage and get the JOB_EXECUTION_ID from source it self then I am not getting any error. But we have to generate JOB_EXECUTION_ID value at run time.

prashanth.spl · Post by **prashanth.spl** » Mon Jan 03, 2011 11:06 am

Hi Santosh,

May i know which version of datastage and Teradata are you using now?

srai · Post by **srai** » Tue Jan 04, 2011 12:15 am

prashanth.spl wrote:Hi Santosh,

May i know which version of datastage and Teradata are you using now?

We are using DataStage 8.1 (UNIX), Teradata Connector 12 Version.

prashanth.spl · Post by **prashanth.spl** » Tue Jan 04, 2011 12:56 am

Have you installed all the connector patches in server and client? These patches are on top of 8.1 Fix-pack1.

srai · Post by **srai** » Tue Jan 04, 2011 4:33 am

We have already installed the 8.1.FixPack.1.

Could you please let us know which pack we need to install to resolve the issue?

prashanth.spl · Post by **prashanth.spl** » Tue Jan 04, 2011 4:47 am

Please check the below link.

http://www-01.ibm.com/support/docview.w ... wg24026478

srai · Post by **srai** » Tue Jan 04, 2011 11:59 pm

Thanks a lot for information.
I will check with IBM Support Team.