DSXchange

All, I need to create a second project in Datastage 8.5. I have entries in the .odbc.ini file for a set of 3 databases. In my original project, those databases are referenced as dwedw, dwhist and dwstg, and those names appear in the .odbc.ini file. In my new project, I want to have those same three ...

I was just confirming that the reject link wasn't the way to go. It looks like we'll have to handle it in the SQL itself. Thanks for the info!

I have run into a situation where the data is not consistent and I'd like to reject incoming data rather than fail the job. However, I don't seem to be able to successfully compile a job if I add a reject link to the Oracle connector source in my job. Is there any way to do this? Or any way to make ...

Nobody?

I'm a little confused as to whether Datastage 9.1.2 supports Oracle 12c as a source/target database. I did a search, and at first it sounded like in order to use the Oracle Connector, you needed to be at version 11.3.1 of Datastage (but using the 11gR2 client). But I've seen a couple of posts where ...

It actually appears to stop when it starts reading the Oracle connectors attached to the lookup. The one thing that concerns me is that there are a lot of lookups (at least 15). One thing is that we have multiple dates that need to be looked up. So I have a Copy stage that duplicates the single read...

Just curious, are there any other logs I should be looking at other than what is in Director? The 256 error is very vague, and I'm looking for something that will give me more info.

Strange problem. I have a job with an Oracle connector for source and target. The source connector leads to a lookup stage that has several lookups, then outputs to a surrogate key generator, then a transformer and finally the Oracle target. When I was originally running this job, it would abort wit...

Thanks for the response. It seems like that will tell you who is currently logged in, but I was looking for something that could be run nighly and let a sysadmin know who was logged in throughout the course of the day. Is that possible?

I'm wondering if there is an easy way to get a daily report of which users have logged into Datastage over the course of a day. Is this information stored anywhere that is easily accessible? Is there any kind of script that a sys admin can use to access this information??
Thnaks!

WHen running jobs under Solaris, we have occasionally run into issues that appear to be related to running out of memory on the server. When I run the 'top' command, I get a line like this: Memory: 32G phys mem, 7437M free mem, 32G total swap, 32G free swap However, no matter how low the phys memory...

All, I was attempting to install the Datastage Client (8.1) on a Windows 7 machine. The client install appears to work fine, but when I try to run the Update Installer, it will get through the portion where you choose the install directory. When you try to browse to the ispkg file to install, it fai...

chulett wrote:Don't use the substring function, use the substring operator - the square brackets: YourField[3,5] takes 5 characters starting from the 3rd. That syntax is universal across the two products.

Ah, you learn something new every day! Thanks!

the transformer in PX has the same set of string functions as Server. But if you have fixed width columns with no separators it would make more sense to declare the columns appropriately in the sequential file stage and save reconverting them in a transform stage. That's the thing, I tried to look,...

All, I am attempting to load a flat file into an Oracle table where there are no delimiters for the data. THe job is being ported over from Server edition, which was easy as the transformer had the substring function, which allowed me to break the one long string into columns based on position. Howe...