DSXchange

Thanx Ray. You are correct, actually the file is having 12 defult nodes and 12 "DB2" nodes. Just to understand the logic I pasted only a part of the file's logic. Then according to you, 12 default nodes will be assigned to non-DB2 stages and 12 nodes fot DB2 stages, am I right? Now in this...

Hi, Can any body explain me the following code of the configuration file? And what will be the difference when "DB2" word is used ?? I am bit slow in understanding the inner logic of the file. :oops: { node "node1_1" { fastname "brhaspati" pools "" resource di...

Since you are using a Sequential File as a source, I dont think so that you can populate sysdate and jobname except in Tfr.

Sorry Craig for replying late.
I checked there but still got no help.

I got the solution,
Sorry guys, the issue was due to incorrrect data.

I am sorry Ray, but I didnt get you.

Ok

Enable Microseconds in the Extended properties.

2 Days and still no response from anyone!!!

Use these variables in the Tfr
input.Col = svOldKey
If svOldKey = svNewKey then svCount1 = svCount1+1 else 1 = svCount1
svOldKey = svNewKey

And in the output use constraint as sv2 > 1
Thats it.

Hi,
I am using DB2 connector as my target. Before writing into the database it offers 'DB2' and 'DB2 Connector' as partitioning method. What is a DB2 connector partitioning and how it is different from DB2 partitioning?

Use Convert() function in transformer

Thanx Craig :D

@chulett I have checked in the pdf and was surprised to see that both defination are almost the same. Create cluster key change column This property appears for sort type DataStage and is optional. It is set False by default. If set True it tells the Sort stage to create the column clusterKeyChange ...

@Pandeesh I am just checking the count in both source and target table. Like count(distinct primary key) in Src should be equal to count(*) in Tgt. Also in my job I am upserting my Tgt table with the latest record i.e. I can have multiple records of my PK from thr Src(no constraints in Src table) bu...