DSXchange

There are currently no certification programs available from Ascential. One may be planned soon.

You will need to contact your UNIX administrator for this problem. RSH is highly dependent on the system's security. Type "man rsh" at the command prompt to learn more about Remote SHell.

Sorry for not being much of a help here.

*dance*

Okay, lets make sure we are on the same page: 1. You are doing a lookup stage, with the "Continue" option -- ensuring that the data continues. 2. You have an input link to the lookup with the following fields: KEY, VALUE. 3. You have a reference link to the lookup with the following fields...

You need to sort your data in order to maintain control in this environment. Sort/partition only on the key fields, and sort only on the dependent fields. You can control the processing of data in the stage variables with the transformer. In fact, stage variables are executed in order received, so p...

Use a buildop stage.

So basically, you're stuck with Transformer.

Sorry.

Feel free to ask for an enhancement for the modify stage, but I doubt this would happen (modify is primarly used to fix the datatypes, and copy columns.)

I suspect that the path you have for that library is different on both projects. If you migrate to different projects that points to different libraries, a force-compile is necessary, even if you migrate the executables.

A better solution would depend on your setup.

Why not pull a single value with a lookup dummy field, join it, use a surrogate key generator stage to generate surrogate key, and do the math (surrkey + generated_key). This will be a MUCH more performant solution than what you are doing originally, and even far more so than what you are doing now.

I could have sworn that if you call it via the sequencer, it does pull the limits you imposed on it and carry that limit through the jobs.

At least, it doesn't abort on 50 messages for me. But then I generally turn off the warning limit on my side. I will have to investigate tomorrow.

Hmmmmm.... I haven't used the difference stage. If you still have this problem on Monday, private message me, and I'll investigate. Edit: You do know that you can change your warning limit defaults? I would bet that you do know that. Hope you don't have one of those clients that demands 50 warnings ...

I believe it's how the stages work, and based on limited experience using the sort stage apart from the stage it's being used for. Typically, for the remove duplicate, I would use the embedded sort. However, I think Remove Duplicates sorta expect that data be somehow sorted beyond just the key. If y...

Hi , Which is best tool for handling 20TB to 30TB Data ? Compare between DataState or Ab Initio? DataStage EE. Seriously. There is a challenge out by Ascential to anyone who can defeat the benchmarked performance (I don't have the specific URL handy at the moment), and NOONE, not even Ab Initio, co...

Bilwakunj wrote:The values for the primary key columns may be different or same also for the other columns values may be same or different.

Change Capture Stage.

In Transformer.

Other solutions would be to ensure that your input data have that metadata defined (varchar(200)).

Would be nice, but would require DataStage to be able to see between each projects. It's like Oracle being able to see different databases. Possible, but not really in the design plans.

But do keep an eye out -- there's something big coming in migrating those shared objects between projects.