DSXchange

Quelle embarrassment!

It's not impossible that, at some future time, PeopleSoft may adopt Quality Stage as the preferred tool for name and address cleansing and, maybe, certification.
And the RTI components may end up being useful as Web services supporting the PeopleSoft application!

Q: is there any particular reason why DWH tables contain char instead of varchar ? A1: There's the obvious one; whoever issued the CREATE TABLE command put them there. A2: In some databases (probably most) extracting CHAR is far more efficient than extracting VARCHAR, at a physical level, and defini...

Still in India, coming up to 21:00.

I doubt that you can have two simultaneous writes to the same Sequential File. Try this design instead. SeqFileA------->LoadTransform-------->universeA Using ExecTCL from the before-stage subroutine in the Transformer stage (which is executed before any rows are processed), execute the command Clear...

At least two built-in functions.

DTX(n)

Iconv(n, "MX")

You can also use variants like Iconv(n, "MCD") and Iconv(n, "MCDX") - or maybe that last one's Iconv(n, "MCXD") - it's been a while since I played with them. Check out the DataStage BASIC manual or on-line help.

Enjoy!

Keep in mind, though, that most bulk loaders prefer fixed length format files, as does Quality Stage.

If you insist on doing it in code, and you want BETWEEN comparisons, why not use a B-tree file (Type 25) rather than a hashed file? Then you can skim left and right along the leaf nodes using the BSCAN statement.

It shouldn't be a problem, as you're not comparing or sorting or joining during the load process.

If you're grouping a column in the Pivot stage and that column contains unique values then, just like in SQL, there's nothing to group.

Can you post a specific example?

Does your database support a CASCADE rule on DELETE ? If so, why not use that?

In a word, laziness. People know it's not essential for operation of DataStage, so don't bother. In many places the same problem exists for documentation; people realise that it's not necessary for operation of DataStage so they don't bother with that either. It's a sad indictment on the way the wor...

If you try to update and the row does not exist, the update will fail. In this case you need to do an insert.

If you use a Dynamic Relational Stage you can flick between the two and figure out the differences.

Excel is probably reporting the column data type as NVarChar. Can't remember the workaround for this; do a search for NVarChar on the forum.