DSXchange

Hi,

Look into this post. That should solve your problem.

HTH
Rich

Hi Dsnew,

Multiple Instance jobs are jobs which can be run at the same instance using different invocation id's. It has no relationship with sequencer.

HTH
Rich

Hi bcarlson,

I have both Orchestrate 6.1 Operators Reference and Orchestrate 7.0 Operators Reference. In both of the guides it is the last chapter named "The Teradata Interface Library" in which you can find this information.

Both these pdf's have references to teraread operator.

HTH
Rich

Hi Bilwakunj, My first thought is that there might be a problem with the partitioning. Yes you should use hash partitioning on keys for both the input links to the join stage. Check whether the order of keys in the hash partition is same in both the input links. My suggestion is that you run the job...

Hi Sriram,

Pls go through Chapter 2 of parallel job developers guide. Also search the forum. It has been discussed so many times.

Rich

Hi Naren, Write a small routine to get the row count into the sequential file. Do a search on this forum and you would get the routine. Result = DSGetLinkInfo (JobHandle, StageName, LinkName,DSJ.LINKROWCOUNT) Use a routine activity in the sequencer to run this routine. Based on the trigerring condit...

Hi Amitava, Using the NVL function in oracle will not resolve the warning. The record will not be discarded but the warning will still persist. The best way to handle this situation is using the Null handling feauture available in Field properties of sequential file stage as described by Eric and Ra...

Hi Vikas, I have used the following query in Datastage Administrator command window and it works perfectly. SELECT DS_JOBS.NAME, DS_JOBS.CATEGORY, DS_ROUTINES.DSRID FROM DS_JOBS, DS_ROUTINES WHERE DS_JOBS.JOBTYPEIND=DS_ROUTINES.JOBTYPEIND AND DS_ROUTINES.DSRID='TestRoutine'; Have you selected the co...

Hi Bilwakunj, Before we go ahead I need some info 1. What is the error message you are getting when the job got aborted? 2. How do you confirm that it is because of StringToDate function used in the Transformer? We have used char(10) columns from input and have coverted them into Date using the Stri...

Hi T42,

T42 wrote:If it's a remove duplicate, you need one extra sort field beyond the keys.

Can you explain why this is so in the case of Remove Duplicates Stage and not in the case of Aggregator?

TIA
Rich

Hi,

We had a similar problem when we started working using oracle enterprise stage. Hope this link helps.

Rich

Hi,

You can delete the Universe table(Hash file) using DELETE.FILE command.

HTH
Rich

Hi Pavan, A dataset is a collection of data files and a contol file with .ds extension. If you use the rm command you remove only the control file and not the data files. Use 'orchadmin delete' command which deletes both the control file as well as the data files. Delete the intermediate datasets in...

Hi, Look into these links it will give you some information. http://www.dsxchange.com/viewtopic.php?t=91381 http://www.dsxchange.com/viewtopic.php?t=91509 Develop a test job using row generator to load data into a dataset and a fileset and try to work on them. You will get more info. Just think of f...

Hi Naren,

In RT_LOGnnn, nnn is the job number. You can get the job number using the following query

SELECT JOBNO FROM DS_JOBS WHERE NAME='jobname'

You can describe the DS_JOBS hash file using LIST DICT DS_JOBS.

HTH
Rich