DSXchange

It is not possible to dump the contents of a Lookup File Set. It only supports "GetByKey" functionality.

You can not add users, only operating system group names. That's why I was dubious about whether they exist in version 8, where the DataStage roles are mapped to domain users/groups.

Search would be favourite. This has been answered many times over the years that DSXchange has been operating.

If you have version 8, you use the SCD stage. If you have an earlier version you use any stage that can auto-commit to persistent storage.

DataStage roles can be seen from the command line by listing the operating system files in which the groups associated with each role are recorded. Names of these files are like .operator.adm for the operator role, .developer.adm for the developer role. I do not know whether these files are still us...

It's not possible to schedule reset of an aborted job unless you can reliably predict when the job will abort.

Just the TNS name should suffice. The Oracle client can pick up everything else it needs from tnsnames.ora file.

Increase the SLEEP interval in the routine. SLEEP should not consume any CPU.

This IS the right forum, and don't dismiss the IBM suite out of hand. There are lots of reasons to go with that as a solution, not least that the metadata are available to all the tools. Get a copy of the "joining the dots" presentation from last year's Information on Demand conference; it will show...

It's a bad day when you don't learn anything!

As to how widely it is used, I have no idea. I have seen it on a couple of sites where data volumes are large, and the vast majority of queries were not interested in non-current data - the idea of Type 4 is to speed those queries.

or

Actually, it's not really related to the metadata at all. The requirement, if I read it correctly, is to find a row based on looking for a "search key" value in any column in that row. The only metadata limitation would be one of compatible data types. As Arnd said, the optimal solution will depend ...

Welcome aboard. There are two possibilities as I see it. One is a "source to target mapping" (or "target from source mapping") document, probably produced by a Business Analyst. The other is a prototype job , which contains the bare bones (for example parameters, stages without properties) that can ...

Jessie wrote:how to do left join or left outer join in transformer?

A lookup from a server Transformer stage is inherently a left outer join; it returns null for all columns on the reference link if the lookup does not succeed.

Upto my understanding, the Requirement is to create output columns which need to be as many different values as in the particular Column of the Input records. If the assumed requirement is correct, Solution is most probably impossible, since the creation of Input/Output medadata should not be depen...