DSXchange

Regarding the FK relationships if you notice on the Oracle doc that you sent there is a separate section that describes this point as an important topic, masking fields while not loosing the FK relationship. Of course, I understand that. Not my first rodeo. I'm just curious (and looking for an answ...

Then you'll need to build your own interlude to sendmail as it's not possible out of the box. Look at the DSSendMailTester routine for some help with that.

I would echo Ray's Job Control suggestion but it does involve a level of knowledge of BASIC and the API. Or as Arnd notes, script it using dsjob.

I'll say again... masking is not the same as encrypting and any encryption algorithm is inappropriate for a true masking scenario because the data is no longer appropriate for the field. I'm also curious what fields you need to mask that would be involved in FK relationships? This is more for my own...

Seeing as how "AW" are Arnd's initials, I'd wager it's custom.

Arnd, I don't think anything was detected as they said that they "read that sometimes these functions generate the same value for different input strings". The chance is small and I don't really see that mattering when you're just doing masking. Speaking of which, do you really want to put...

Create a grouping column then pivot. It can be as simple as a number you increment every 3 rows and then drop post-pivot. Be careful with your partitioning, of course. If you are on 8.5+ you could use transformer looping for this rather than the Pivot stage.

What kind of help do you need? What have you tried and what issues have you faced? Have you ever worked with XML before?

Or split off a link to an aggregator with that value and then to the second target. Your aggregation method can ensure it only gets one row at the end of the job, if that's what you are trying to do.

wjblack74 wrote:I'm using an Oracle connector and am trying to use one of the incoming columns as part of the after SQL statement within the connector.

You can't. The before and after areas are not aware of nor have any access to data on the link.

peep wrote:I think the time stamp between client and the server is differnet. thats the reason i am encountering this issue.

No, that only can affect the Director (not the running of jobs) and there is a very specific message you get from the Director when the times are out of sync enough for it to care.

Does your list of 25 jobs change? If not, just add the 25 stages to the Sequence job - what's the concern with doing that?

It certainly is possible. Do an exact search here for the DSSetUserStatus function which will allow exactly that - pass the retrieved value back which can then be leveraged by anything downstream of that point.

Ah... guess I was thinking of the wrong thing.

(actually, I just deleted the accidental hijack of the other thread since this had already been created)

Is this shared drive acccessable from the ETL server?