DSXchange

Create a virtual column on the table, and use that in your join.

Why is 101,SUSHMA preserved, rather than 104,SUSHMA ?
What exactly are your transformation rules?

Don't transfer FldName to the output (on the Output Mapping tab).

Use a Field() function to extract the date (everything before the first comma) and time (everything after that comma). Use Left(), Len() and Right() functions to extract the date components, then use date conversion function(s) to convert to date, and finally a data type conversion function to conve...

Do you have a reject link from your Column Import stage?

These drivers come with a 30 day initial trial licence that can be used for other things, like BCI Functions in server routines. This message can occur once that 30 days has elapsed, but should not occur if you are using the drivers validly (that is, from ODBC stages).

Why don't you measure the baseline performance? How fast can your server read this volume of data without DataStage? Create a DataStage job consisting only of a Sequential File stage and a Copy stage with no output. How fast does that read the file? Multiple readers may help. Play with that certainl...

This problem is most easily remedied by talking with whoever is producing the file. Having some kind of threat available would also help.

What I'm reading is a desire to take a table level lock for the duration of all three jobs running. Basically, the answer is no, because the three jobs will use separate connections (separate database user numbers), and they can't all own the same lock. If you want to build transactions of this kind...

A bit overly complex but, as you say, it works. I'd use Iconv(), arithmetic, then the MONTH.FIRST transform.

DS_AUDIT does not record logins. I'm pretty certain that login information is not stored anywhere in XMETA either other than when sessions are active.

When a DataStage client is attached to a project, the project directory is its attach point in the file system. This is not negotiable. Require your developers to follow directions or depart.

That does not seem to me to be a pivot. Can you explain in words exactly what you are trying to accomplish?

They should run "as is", although best practice is to recompile if only to verify that you've not forgotten to migrate any dependent components.

Yes, by looking at the Engine Credentials in the web console for Information Server.