DSXchange

Thanks a lot ZULFI. This works !!

I have a small doubt. Please help My source file has a col A (datatype varchar(12)) and I want to populate target col B (Datatype Smallint) with the logic that if the col A is zero then col B = 1 Now the concern is that as the source col A is having length as 12, I can get anything from 1 zero to 12...

<removed>

Moderator note: please don't post that that kind of help here, it won't be tolerated.

Sorry

I ahve a parallel job in whic I am using Constarints on lookup. I am putting 2 conditions and they are like 1) src.a = ref.a ; If condition not met - drop; If lookup failure - drop 2) src.b = ref.b ; If condition not met - drop; If lookup failure - drop Now if I have 2 rows in my source which is sat...

So does it mean that only for the transformer you are using a SC. Why do so ?? Directly put the transformer in the job. If its very complex logic then only use the SC. And also did you check the output columns validity??

@ PhilHibbs - I want to achieve exactly opposite of this. If I get a multiple match after a doing a lookup then I want my job to abort. How do I do that? Any Idea?

Well I don't want to remove duplicates nor I want unique records from my lookup. All I want is to abort the job if lookup returns multiple match. I guess this can be done in 8x versions of DS. Has anybody implemented thsi in there jobs??

In Lookup stage in Datastage, I want to abort my job if I get multiple matching records from my lookup table. How do I do this in the lookup stage??

I have already calculated X and Y before in my job by using a transformer.
Can you please ellaborate more on how to mention this loop condition in the transformer stage as I am new to this tool and I'm trying this loop condition for the very first time. Thanks for your inputs.

I want to implement a loop in the transformer stage in datastage for a column name Col1(varchar). Source Column = SrcCol1 (varchar) condition is : X =7, Y = 1 {Set n = 0 Loop (until I get a match on doing the below lookup) or (X-n = Y) Lookup Substring (SrcCol1, 1,X-n) in a Dim1 table n = n+1 Endloo...

It can easily be done in the Transformer stage. Simply calculate the length in the current record and compare with the length in the previous record. If it's smaller, update the min. If it's larger ... This is how I was planning to do it, But how can I identify the 1st row and the 2nd row and so on...

Just add one more column in transformer stage which contains the len(dialled_string). Then use Aggregator stage and find min,max values. Thanks Pandeesh, I will try this one in my job.. Just a thought is there a way to do this in transformer stage?? Also based on these minimum and maximum values I ...

Hi, I have a table with the following data -------------------------------------------------------------------------------------- Dialed Digit | MCC |MNC +46 | 240 |AA +46675 | 240 |02 +467230 | 240 |02 +46252 | 240 |07 0 | 240 |07 --------------------------------------------------------------------...