DSXchange

In case of Oracle we have the option in odbc.ini,We can specify the alternate server in odbc.ini

Looking for the similar option Sqlserver 2008.
Will it work if we specify the alternate server in odbc.in while creating DSN for sql server ??

Hi All, We have requirement to load data in SQLServer 2008 Standard R2 database. In addition we have to handle the Database fail over. If Principle server is down, then jobs should load into the mirror server. Do we have any option in Datastage/DSN to specify the Mirror sql server. ?? Thanks in adva...

Please suggest the specific Product/version which can help in pulling the Real time Data from SQL server to DB2. 2 to 3 sec delay in getting the data is acceptable in my case. Will this approach work if i try to execute the DS job multiple times in a loop. using ksh or loop stage is Datastage.We are...

Hi All,

We have the the requirement to load the Real time data from Sql Server to DB2 using Datastage 8.1

Any record inserted/deleted/updated in the sql server table needs to inserted in the DB2 table.

Kindly suggest any design/stages or approach.

You can mask the final byte with the BitAnd() function. ... Hi Ray, BitAnd() will compare the actual value in the input field. 1214 000F AND 1214 000C Are same becouse the have the same value. Unsigned and Positve number have the same value. I need to identify if any signed number comes in the Unsi...

Hi Ray, I am not sure about how to read the oracle table from the shell scripts but in the teradata we can write the bteq command in the shell scripts or we can call the bteq scripts. Now kindly let us know how to read the hash file in unix. OK here's the deal. A hashed file (note: it's not a "...

We are inserting data into a Teradata table using the Teradata Enterprise stage. We observed that whenever there are zero rows in the dataset ( that is the input to this stage), the job fails with the following error:" The runlocally() of the operator failed" Is this a shortcoming in the E...

Hi,
We are facing problems reading date fields with value '1800-01-01'. The database is Teradata and the stage being used is Enterprise stage. It has no issues for all dates starting with century 1900 onwards. Is there a way to ensure the Enterprise stage can read such fields?
Thanks.

For all insert jobs, the Teradata Enterprise stage needs "Create table" rights to the database where the target table is present. This is because it creates intermediate work tables to load the data and currently we do not have the "create table" rights to the target DB. Is there...

For all insert jobs, the Teradata Enterprise stage needs "Create table" rights to the database where the target table is present. This is because it creates intermediate work tables to load the data and currently we do not have the "create table" rights to the target DB. Is there...

For all insert jobs, the Teradata Enterprise stage needs "Create table" rights to the database where the target table is present. This is because it creates intermediate work tables to load the data and currently we do not have the "create table" rights to the target DB. Is there...

The odds are that your job is bottlenecked on CPU; especially if your source and target files are sequential ones as you've indicated. If you have a multi-cpu system or one with CPU capacity left ... Hi Everyone, I was just looking for the option how to validate the data by using the the datastage ...