DSXchange

Not recognize. You have to tell DataStage how the data are encoded. But it can then handle it satisfactorily. How it does this is to place a "map" at every boundary between itself and the "outside world" (your data). These maps translate between the external encoding and Unicode,...

Can you see job names using Director client?

NLS map

BIG5 is one of many supported character set encodings. GB2312 is also supported for "the other" Chinese character set.

ds_sai wrote:Try this....
StringToDate(DSLink3.Testdate,"%yyyy-%mm-%dd")

If you give a man a fish, he's not hungry for a little while and is then hungry again. If you teach a man to fish, he need never be hungry again.

Yes. In DataStage it's called "National Language Support" and has to be installed and enabled (Americans typically prefer not to have to worry about character sets).

Is this an interview question?

WHY must you use a Transformer stage?

Have you performed a Search of DSXchange? Very similar questions have been asked and answered even quite recently, such as this one.

Partition using a key-based partitioning algorithm on the first Sort key or, if this does not yield more distinct values than the number of nodes, on the first two Sort keys.

If you're going to run this from a Routine activity or as an after-job subroutine (and these are the only sensible places to perform reconciliation) then a parallel routine is not what you want. You need a server routine or, perhaps, a job. Please clarify your requirement.

Is MS SQL Server being used for the Information Exchange repository database (XMETA) or just for data? If just for data it should be sufficient to alter the DSN entries in the .odbc.ini file on your Engine tier (assuming host name resolution for UNIX has been fixed up /etc/hosts, DNS, etc.).

kennyapril wrote:Please suggest if any changes are required for improving the match rate or count ??

The match rate is primarily driven by your data. It may be impossible to "improve" it. If the match specifications are correct, the matches in the data (and only the matches in the data) will be detected.

I suspect that subrat needs the offset in the original string, but that's just a combination of the Index() function already mentioned and Len() function. The results of each are integers so can be added.

Yes. It does.

Probably not best practice. But that's how it works at the moment. Take it up with IBM.

subrat wrote:I think it would return =TEST from first example as index will keep the first position. Is there any function to return last character of substring in stage variables

There's nothing in the original specification that asserts that "TEST" will always follow "ABC=".

Welcome aboard. What happens if you run on two nodes in development? When something works on one node but not on more than one, it's highly likely that you have not gotten the partitioning right. Please don't "shout" (use all upper case). It's bad netiquette not to mention offensive. And l...

Can you not use exactly that expression in your VALUES clause of your INSERT statement or in the SET clause of your UPDATE statement?