DSXchange

This will still fail if the house number is ten or more digits, but I've never encountered any of those!

Are the sampling characteristics set identically?

I don't believe there is. No mention of one comes up in Help, though no mention of the server one comes up in Help either.

Depending on what you want to accomplish either an External Filter stage or a Wrapper stage may achieve your ends.

No.

For sparse lookups there are several restrictions. Among them are that only DB2 Enterprise and Oracle Enterprise stages may be used, and that these must be connected directly to the Lookup stage (no intervening stages on the reference input links). Are all those conditions met?

At a quick glance that looks OK, provided that there is a field called tdatetime in the input stream. Are the fields on both sides nullable?

How and where is tdatetime derived?

Are any rejects being reported in the job log of Job 2?
Do you have reject links to handle these?

I don't believe there are any DataStage-provided parallel routines.

What are your parallel job tuning credentials? That is, why did they give you the task? How much experience do you have in this area?

MatchField(InLink.TheString, "0X5N0X", 2) "0X" matches any number of characters, "5N" matches five numeric characters. The function returns that part of the string that matches the second component of the match pattern (that is, the first "5N" in the string). It returns "" if ther...

It expects the format of an Orchestrate record schema.

tagnihotri wrote:what is brain and whats the purpose!

This is actually one of the all-time favourite philosophical questions! Part of the bigger question of the mind/brain duality question.

Rats!

One stage, two links. HashedFile : : inserts V ---------> --> Transformer ODBC ---------> updates Hashed File contains keys from target table, lookup determines existence of key in target table, which makes insert/update decision.