DSXchange

Hi,

I have to generate SurrogateKey. In S2T they did not mention any thing.

1.NextSurrogateKey() function in transformer.
2. SurrogateKey stage
3.( (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1)

Can you suggest me which one is best approach in above list.

Hi,

I have one query please suggest me.

I want to use teradata connector as source.

when I should use bulk mode in teradata connector(as source).

please explaine me in terms of rows.

I am getting same error. Any body knows solution?

Is it multiple instance job?

Hi, This is the error I am getting. TGT_CSPRC_BDNDETL,1: RDBMS code 3798: A column or character expression is larger than the max size. SQL statement: USING (NUMCHILD INTEGER, BDN_LEVEL SMALLINT, SRC_SYS_ID VARCHAR(15), LOAD_ERROR CHAR(3), DATA_ORIGIN CHAR(3), CREATED_EW_DTTM TIMESTAMP(0), LASTUPD_E...

Hi, My job : oracle connector stage -> transformer -> teradata connector stage. source DDL(oracle): COL1 CLOB COL2 CLOB Target DDL(TERADATA) COL1 CLOB(1048544000) CHARACTER SET LATIN COL2 CLOB(1048544000) CHARACTER SET LATIN DATASTAGE(source): COL1 LONGVARCHAR(length is not mentioned) COL2 LONGVARCH...

Hi, My job : oracle connector stage -> transformer -> teradata connector stage. Table contains blob,clob data types. I tried the options with fast load, multi load,tpump. But there is no use. I came to know that blob,clob data types does not work for any load in the teradata.But Immediate option is ...

HI, Recently we installed datastage 8.5.0.1 on redhat linux. we are unable to see the default environment variables in adminstarator and also unable to see the user defined variables. Intially we created some user defined environment variables. Some times it is removeing user defined varibles while ...

for working db2set command can you please let me know the steps.

datastage internally it is executing create_xmeta_db.sh script. inside the script it is executing below commands. db2set DB2_INLIST_TO_NLJN=YES db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON db2set DB2_REDUCED_OPTIMIZATION=YES it is unable to run above commands. it is showing error commond not found. in ...

for installing DB2 rpm -ivh IBM_db2cc81-8.1.0-0.i386.rpm software need to be installed. Is it corect?. why because I try to run the below command I am getting error.
db2 -stf create_xmeta_db.sql
-bash: db2: command not found.

because of this It is unable to install db2. can you please conform this?

Hi, Here I am attaching the response file as well. I am useing only IBMDB2(plugin). not useing any database apart from DB2. ################################################################################################################# # suite.installLocation is the absolute directory path to wher...

I am looking into log file. between from line no.570 to line no.574 in logfile: Begin: [actionId = update.information.server.port, installUnitId = ISFServer] End: [actionId = update.information.server.port, installUnitId = ISFServer] between from line no.575 to line no.2661 in logfile: Begin: [actio...

DB2 did not install.

HI, I ping localhost from on the server. it is pinging to 127.0.0.1. yes I am useing root user. as you said DB2 failed to install could be in one of the earlier install log files. so I want to remove log files and unstall the software. could you please let me know what are the steps I should do to u...