DSXchange

I guess I just wanted to know if I missed anything on my checklist, and if so, what.

I am trying to confirm my security checklist for a multi-user configuration. So, to answer your question, yes.

I was hoping I might get a checkpoint from the group. I have read thru most of the posts related to UNIX and project level security and the great FAQ post (content by Aaron Titus), but I wanted to make sure that all of the suggestions applied to v7.5 (on AIX). I have included a list of TODOs, would ...

I have a similar situation - two sequential files going into a join. However, for a join to work, the links must be sorted/key partitioned. What would be best practice - set the sort/part keys on the output link of the sequential files or have an explicit sort stage between each file-to-join links?

Yes - I was hoping to build out sandbox environments for my developers and of course Fedora isnt supported, but would it work.

I did several searches, but I havnt been able to find any comments about installing V8 on Fedora - for developer (sandbox) usage. Any thoughts?

Agreed - good point. Now the users require that I specific possible matches too - so on my second pass they want me to only match on the left most source string to the left most target string or more

for example a source of 12345-001 would match on any target that begins with 12345*

Substring of what? I am trying to match on a wildcard. A substring presupposes a known length in advance - I will not know the length of the matching string, just that I want a match on the leading left characters (or more). HTH For example, given an input of Policy # 12345-001 and a lookup value of...

I am trying to perform a lookup based on a sub-string that contains a like statement. For example, Policy # 12345-001 Lookup source will have 12345-009 and id 998 I want to lookup based on 12345-* and assign the id 998 (the parent policy id). The lookup and join stages appear to expect "keys&qu...

I am experiencing the same issue - is this a bug with the load/upsert settings of the oracle enterprise stage?

Thank you.

I have read posts regarding regular expression in filters, but would anyone please help with understand if the Modify or Transformer stages support them too? Can they be used for parsing values, or only to exclude records?

Thx - T

Favor - please explain the specific details of the file transfer. You are using native ftp? you are transfering the file as binary or ascii?

You might consider do a binary transfer and then using the UNIX tr comman to translate control-characters. Thoughts?

Maybe "row" was confusing. For example, I want to compare the previous record with the current record to apply survivorship rules. How would I do it? Must I use C++ to do this type of operation?

Are you transferring the file using NDM to do the transfer? Verify that it does not have a predefined line length.