DSXchange

You can change the NLS_MAP in the Stage Tab of the Sybase Enterprise Stage.

I believe you need to talk to the DBA to know what's the iso_1 means?

If you follow a proper process, then the update is given. For example, any changes within Information Server is always capture within the xMeta so there's no problem. What's the proper process? In your case, you're talking about Data Lineage. We use it do allow us to assess impact on changes. In thi...

About DataType Binding for Oracle - http://www-304.ibm.com/support/knowledgecenter/#!/SSZJPZ_9.1.0/com.ibm.swg.im.iis.conn.oracon.usage.doc/topics/data_map_to_ds_oracc.html It provide you the Oracle Environment Variables for the Oracle Connector to handle some internal binding. e.g. VARCHAR2 to NVAR...

Hi DataStage (Parallel Jobs) is already based on "distributed" computing by itself as it is based on Shared Nothing Parallel Architecture. We have been doing this even before Hadoop exist via MPP or GRID architecture. Putting it on Hadoop will just make it slower since we need to go throug...

Hi

We do have the Information Server Manager (ISM) from DataStage 8.5 onwards that allow you re create and deploy package (DataStage Jobs) across Server (as long as connection allow).

The ISM is also how we can integrate with the Source Control Tools like RTC, ClearCase, etc for those packages.

For Windows, you need to use the 32 bits ODBC to configured based on 32 bits driver if you're using the 64 bits Windows. You also need to add the necessary DSN name in the uvodbc.config in the following directory - DSHOME/Server/DSEngine - This will need to have all the DSN for all the ODBC required...

In the View just beside the Edit you can enable the bar. If it is already check, just uncheck and check it again.

Hi

This link provide you the instruction - http://www-01.ibm.com/support/knowledge ... inodb.html

I hit problem using the stool so I just use the SQL option to delete it directly.

Typically I'll create a RAID 5 on those disks to allow even distribution of I/O non matter how many nodes I do for the Configuration Files and it also provide Redundancy.

If you sort the data then you should be using "sort" in the Aggregator. Hash is used if you didn't "sort" the data in adv. I have a job with the following design. From dataset I have one copy stage and from that copy stage one link goes to aggregator stage and another link goes t...

If you sort the data then you should be using "sort" in the Aggregator. Hash is used if you didn't "sort" the data in adv. I have a job with the following design. From dataset I have one copy stage and from that copy stage one link goes to aggregator stage and another link goes t...

If you sort the data then you should be using "sort" in the Aggregator. Hash is used if you didn't "sort" the data in adv. I have a job with the following design. From dataset I have one copy stage and from that copy stage one link goes to aggregator stage and another link goes t...

Are you using 32 or 64 bits Oracle Library?

What are you using for the Oracle Library, 32 or 64 bits? Which version of DataStage are you using? Are u on 11gR1 or 11gR2? The error "The specified DSN contains an architecture mismatch between the Driver and Application" coming while connecting DataStage to Oracle11g in Windows 7 Platef...

It will be easier if you can provide a screenshot of the job.

When you didn't use Auto? There's no value in Hash partition the Key of Update in the case of Oracle since it is Range Partition by month. In whatever way, you've to do a Re-Partition.