DSXchange

major

from the post it seems there are errors in assembly

xml_assemble_aqi_files,0: Fatal Error: CDIER0802E: The assembly has 2 errors. Please edit the Assembly to resolve

Did you try to see what those issues are ?

Thanks
Major

major

Hi Chulett , thanks for the reply.

Issue has been resolved after using Teradata Connector variant 12

Thanks
Major

major

Hi, I'm trying to do BULK load using Teradata Connector stage, but the job is failing with below error DBMS code 2113: Operator(libloadop.so) instance(1): INITIATE method failed with status = Fatal Error I did try playing with Array Size using 'Immediate' method , but job is estimated to complete 6 ...

major

As of now I'm using 2 different jobs to load the target , but I'm looking to optimize them , and want to use 1 job..

No clue where to start from

Thanks
Major

major

Hi ,

Thanks for the suggestion , but I forgot to mention that there is a dependency between 2 file loads , one file load has to be completed before proceeding with next one

Thanks
Major

major

Hi all,

I have 2 different datasets with their own metadata , I have to do couple of lookups with DB stages and then insert into a same target table.

What is the best design so that this can be done in a single job instead of creating 2 jobs to load dataset to target table.

Thanks in advance
Major

major

Hi, I have some 20 jobs to be renamed from PROD env to DEV env, so I have exported them to a dsx file and very carefully renamed the job names in dsx file. While I try to import them in DEV env I have selected 'Import selected' , but I see the job name unchaned , pretty confused. (Job X is still Job...

major

Hi,

Can you share those details.

Thanks,
Major

major

Hi, I'm using MQ connector stage as Target in Client Mode. We have a situation where when I use 'Test' option for verifying connectiviy for non-SSL queues the connection succeeds and indeed job runs fine when I actually run it also. (Here I'm not using channel table, name) But for SSL enabled queues...

major

Yes, if I go to the sequence job properties-->dependencies , I can see the job X with the type set to 'Job'.
But still when I export the sequence with dependencies the job X will not get exported

major

Any suggestions please..

major

Hi all,

When I right clidk on one of the jobs say X and choose 'find where used ' I dont see the job sequence associated wiht it.
and when I export the sequence with its dependent items this job X is not getting exported

This is not happening for all the jobs though.

any suggestions

Thanks
Major

major

you can pass the current date through the sequene in whatever format you as a parameter to the job , generally , i use currentdatetimestamp(1) not sure if that is the correct trasnform

Thanks
Major

major

hi,

In your case the only other way is to populate sysdate and jobname in the seq file which you are loading to oracle table.

Thanks
Major

major

Code: Select all

SV1 = if a = b then 'true' else 'false' 
......
...
a is nullable 
b is not null 
.....

Also handle NULL values for column a in stage variable 1 (SV1)

Thanks
Major

DSXchange

Search found 166 matches

Teradata Connector BULK Load Error

Different Input layout but same target

Renaming a job name in dsx file is not changing the job name

MQ Connector Stage Test connection using SSL

Find where used not showing all the dependent items