DSXchange

Maybe some esoteric requirement for the mainframe environment only?

Hi, I am getting issue with Websphere FTP adapter for SFTP using launcher with timed event, map was getting failed with "source not available" using with below command. -TV IBM.j2ca.mtr -wtx:schemadir "/export/home/wtxapp/CommonSchemas" -as:userName mercprod -as:password p@ssw0r...

No, IBM posts that installing NLS (globalization) may result in slightly degraded performance.

This is true irrespective of the setting of NLSMODE in the uvconfig file.

CONVERT is not available as an SQL function, but you can include it in an EVAL expression. RECORD is a reserved word in DataStage/SQL, so I've replaced it with ENTIRE_RECORD. I'd also process the other potential dynamic array delimiter characters. Try SELECT EVAL "CONVERT(@FM:@VM:@SM, '~}|', @R...

Try a Force Compile.

Did you think of running the job on three nodes, to match the number of nodes in the Oracle RAC?

I guess I misled you with @DAY + 1. Ignore that.
Use Oconv(@DATE + 1, "DD") = 1

... which is what @DAY is already doing for you!

When you have multiple input links to a Connector stage, it behoves you to check the stage properties as well as the link properties.

In the graphical navigation panel of the Connector stage, click on the stage (rather than on any of the links) to view the stage properties.

Check which inputs are Left and Right in your Join stage.

The stream that is Left should be the stream that is the stream input for the Lookup stage.

Keep in mind also the partitioning and sorting requirements for the Join stage, and the partitioning requirements for the Lookup stage.

Why can't you use @DAY? This is the day portion (as a number) of the current date. It's a system variable.

You might make use of (@DAY + 1) = 1 to detect the last day of the current month.

chulett wrote:Database. Let's start with

Yoda?

Has anyone any experience importing data models (logical, physical or both) from Sparx Enterprise Architect into Information Server repository?

If yes, what technique was employed to bring the data model(s) in?

Ideally I'd prefer not to have to use InfoSphere/Relational Data Architect.

While you must physically read all columns you can, if not using RCP, make use of the Drop on Import property for columns you don't really want to read into the job. Or use a Copy stage to transfer only the columns of interest.

RCP isn't for everything. As soon as you need to name a column in an expression, you have to name that column. There's no way around that fact, unless you can specify generic field names to which you can map your data. But those names need to appear in the job - you can't "name" a column i...