DSXchange

[quote="ray.wurlod"] Ur was a city in ancient Babylonia - the second person possessive pronoun is spelled "your". Are the two fields identically trimmed? ...[/qu Both these fields are from db2 source. Both these fields are identically trimmed in the extract query itself like LTRI...

I'm using Datastage 7.5.1

I was doing a lookup on a filed which has values like 'TCSCLINTGRPID6' on both the master & reference.

It is a varchar field of length 15.

But i was not getting a hit.

Awaiting for ur help in this regard.

Do you mean that need to capture the duplicates or you want to use in the next stage? All my reference links have duplicate entries(only my master is unique),i've to carry over all the dupliacte entries,becoz i'll be again joining the output with another dataset. So how to carry over all these dupl...

You get this warning when your reference links have multiple matching records with input records. So DataStage randomly choose one of them and get the lookup value. You can ignore this for only one of the reference links with an option on the condition tab of the lookup stage. Devi All my reference...

I was doing a lookup with 6 diffferent referernces.

I was getting a warning like ignorning duplicates in the lookup.

I want the duplicates to be propagated to the next level.

How to achieve this.

keshav0307 wrote:what is the reference source? is it a file set, dataset, database ??

I trimmed this field in the source from where it was generated & propagated the field as varchar.

Now i was getting a valid hit.

Thanks for your Help.

If you run the job with a 1-node configuration, or specify "entire partitioning" for the lookup link, do you still get the same problem? ... I was using $APT_STRING_PADCHAR environment variable in my job. I found some spaces padded to that particular field,when i tried to trim it,the spac...

I've to do a lookup where the primary & reference link has a field with value like 'ABC',but the hit was not happening. Since it was a varchar field, I tried triming the trailing & leading spaces,even after also that it was not working. When i pass this field through a filter or tranformer w...

I used the following command & it executed successfully,

StageName.$CommandOutput<1> >= 0

Thanks

Hi, I've a requirement like if a count of a particular file is greater than 0 then my sequencer should abort. So i placed a execute command activity & checking the count of the file by using the command wc -l & at the triggers part, i was giving the condition like if the command output is > ...

If i was running my job today,i've to get the current time stamp value in today field(that can be done by including current time stamp function),but i want the last date of the previous month in one field & the first date of the last month.(If i was running the job today i.e., 30-Apr-2008 ,i sho...