DSXchange

Hi Rafiq, The inputs to the CDC should be your source and target. The output of the CDC should lead to a transformer. Have 2 constraints in the transformer 1. change_code = 1 or change_code= 3 2. change_code = 3 From the transformer use the 1st constraint and lead the records to a funnel. From the t...

Hi Praveen,

For Volume < 10000 rows use Teradata API stage

For Volume > 10000 rows use Teradata Multiload stage.

HTH
--Rich

Loric, Make sure if there any locks on database tables. If you are on Oracle just check the following with your DBA 1. select * from v$lock where type = 'TM' ADDR KADDR SID TY ID1 ID2 LMODE REQUEST -------- -------- ---------- -- ---------- ---------- ---------- ---------- CTIME BLOCK ---------- ---...

Hi Madhavan,

Pls check whether the scratch disk mentioned in your configuration file has enough space.

If possible increase the scratch disk space, run the job and report what happens.

--Rich

Hope this post helps

--Rich

Hi Bakul,

A wrapper stage can be used to execute unix scripts. Also if you are comfortable with C/C++ parallel routines can be developed and used in the transformer.

HTH
--Rich

Hi Brad, We had a similar issue and what we found was a problem with string columns. Both the tables had string columns declared as varchar but during the processing of the job(after CDC stage) the metadata of the string column(s) had changed from varchar to char and back to char from varchar and lo...

Hi Shivani,

These kind of issues occur for one of the 2 reasons

1. Invalid Data

2. Invalid Format used in the transformer function.

Pls provide sample input data as you have already provided the derivation.

--Rich

Hi,

Both the methods will work but what is it that you cannot solve. Pls give more info like the output that you are expecting and the actual input you had provided.

--Rich

Hi Ray, In the director the job does not time out waiting for a resource rather it runs and then aborts. Why is that "timed out waiting for event" not showing up in the director whereas it is being shown in the dsjob status. It is a simple job and uses the following Datastage Basic code in...

Hi All, Iam testing a re-startable sequencer job which has one job activity and a routine activity. In the job activity, the Execution action is - Reset if required, then run. Iam running the re-startable sequencer job from the command line using dsjob. When the sequencer aborts for the very first t...

Hi Arvind, In the CDC stage there is an option known as Change Mode. 1. If you are having a single column for detecting change and if it is a key use Explicit Keys and All Values option in Change Mode. In the Change Keys section add the column. 2. Column Length should never be a constraint. Just giv...

Hi dspxlearn, Use the SEARCH facility in this forum. It has been covered before. We had a discussion 2 days back. Just scroll down the topics list and you will find a topic "About Modify Stage" where you will find what is the correct function to be used for Null Handling as well as a webli...

Hi Venkat,

In the Stage prior to Sequential File Stage there is an option for propogating partition. Set it to CLEAR. The warning should disappear.

Venkat, Do a SEARCH in this forum before you post.

HTH
--Rich

Hi Ray,

The log file needs to generated for both success and failure.

With Otherwise Trigger it will be generated for only one condition.

Pls Clarify.

Thanks
--Rich