DSXchange

rafik2k

You can check after restarting the services of ds server

rafik2k

when i try to run DS on local machine without LAN connectivity it fails to connect Are you running DS client to conenect to to DS Server? Without your LAN connectivity, how is it possible? You local machine must have connection with server machine. Ping the server from you machine and check whether...

rafik2k

Can you see the process using DS.TOOLS?

rafik2k

Code: Select all

 is too much. for instance 1 million !! 
so this can be a costly affair.

If your list of keys is in the table and then perform join at the database level itslef.
That will reduce the overhead of bring entire data into staging area.

rafik2k

One approach is create a hash file for the list of keys.
select all data from db2 database as it is and then in the transformer join this data with hash file using setid and recname, then pull the data into seq file

rafik2k

Code: Select all

Load Immediate = No

This should work when Load Method : Sequential File

What is the File type of the data format? is it IXF or Delimited ASCII format?

When you run the job, is performance statistics showing any rows to the input link of DB2_UDB_Load

rafik2k

If the target field is nullable then you can use @NULL

Code: Select all

If Len(Trim(Link.Column))=0 Then 

Then [b]@NULL[/b]

Else Oconv(Iconv(Link.Column, "DYMD"),"D-YMD[4,2,2]") : " 00:00:00"

rafik2k

What do you mean by transformations?
and what do you want to with transformation??

rafik2k

Do the following step if you want to use plug-in metadata definition:-
Select Plug-in
In your case(for db2) IBM DB2 UDB data acess

Enter Server Name as your db2 Database name, user name,password.
In next step select the table you want to export,select To Category-->then import.

rafik2k

It has been discussed may times.

Search for the post
Here is one
viewtopic.php?t=108857

rafik2k

create one simple job and add a transformer stage on. Go to Transfomer properties-->Click on derivation of a clumn on output link. You will see list of available transformation like DS Macro,DS Rotuine ... You can also create your own routine. For more information 1) search the post for creating rou...

rafik2k

Array size: no.of rows written to or read from the database at a time.
Transaction type: no. of rows committed at the database at a time.

Default value of Transaction type is 0, means all rows will be committed at a time

rafik2k

Better involve DBA to create dsn for you.
You need to create dsn in server where DatStage resides.

For windows environment you can create system dsn using Data Sources(ODBC) under control panel.

Search web for more information.

rafik2k

Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?

rafik2k

Create two dsn for the databases in those server.
Go to Import--->ODBC Table Definition
Enter your dsn name, user name and password.

You will get list of table for the database.

Then import what ever table you want.

Search found 180 matches