DSXchange

You can use Sequencer activity in sequence job.Set Sequencer mode to "ANY"
and connect this stage to your job activity stage (whichever you want).And set triggers expression type to failed for that link in job activity.

Hello, We have 42 different projects on the Development machine.out of these projects we are not able to connect one project neither from Designer,Director nor Manager. It is not giving any error or massage but it keeps trying running and then after sometime it gets hanged. 1.Do you have any idea wh...

How many possible value for type?It only just 3 or more?

nguyenh,

You have to set uvodbc.config everytime ,whenever you create new project.

kashif007 wrote: I am doing an inner join on that one column

What is Data Type for this column?

Inside the jobactivity, where your specifying $CommandOutput, provide the following
Code:

Field(Execute_Command_2.$CommandOutput,@FM,1)

OR simply
Code:

Execute_Command_2.$CommandOutput<1>

Try to Trim your data for Joining Keys.

Sorry for being late, Arndw,
I am using my look up as Hashed_File_A and Hashed_File_B so can you please more explain about how I can implement logic which you said ?

Thanks in advance.

Check this ...http://dsxchange.com/viewtopic.php?p=21 ... ca8#214862

Yes craig,I checked that if I used ''OR'' in Key Expression and condition on link Constraints then it is not working. So , In general 1. If I mapped only 1 coumn in Key Expression and Use 2 columns on Link Constrains, then will it work ? 2.Can anybody please explain working and uses of Key Expressio...

Thanks Craig,
If I use (Source.Y=TableA.Y) OR (Source.Z=TableA.Y) in Key Expression for Column Y of TableA in Left pan AND again put the condition as constrain on appropriate Output Link then will it be fine ?

Can you please advise me ?

Thanks

I have 3 keys (X,Y,Z) in Source and for Look Up I have 2 table (Table A & Table B). For Table A there are 2 keys (X,Y) which I have to compare with that of Source. conditon for look-up this table is IF (Source.X=TableA.X) AND ((Source.Y=TableA.Y) OR (Source.Z=TableA.Y)) then get data from TableA...

After you have installed MQ server, did you get your mqs.so registered successfully? MQ stage simply wouldn't work without registered msq.so. Also assuming that you have put /opt/mqm/lib/3.2:/opt/mqm/lib:/usr/lib in the LD_LIBRARY_PATH of your dsenv. so Istsaur, You mean i have to do following entr...

In 7.5.x and earlier, this is the ONLY choice as it is the only supported scenario. You MUST have the MQ Server co-resident with DataStage Server. Ernie After installing the MQ server on UNIX environment where Data Stage server lies ,is there any configuration i have to made with Data Stage other t...