DSXchange

Director log doesnt say much... It just gives warnings for defaulting values which are not given as change keys or values. Like this: Change_Capture_72: When checking operator: Defaulting "DOC_TYPE" in transfer from "beforeRec" to "outputRec" I am trying "clear par...

Yes I have specified the same sort keys. I have specified all the columns mentioned as CHANGE KEYS as sort keys.

they are in the same order.... Is that right?

Hi, I have a server job which I exactly replicated as a parallel job to make the process run faster. I am trying to compare the files from both jobs (Server and Parallel) with change capture stage to make sure the old process data matches with the new process data. The SERVER job output is a FIXED W...

I'm using hash ..... is there a better option ?

Hi,

Do I have to sort the fields mentioned as keys in the same order as they are in change capture stage?


ie: If i mention the the columns a,b,c,d as keys, do i have top do the sort in the same order (a,b,c,d) ?

Do I have to perform a sort on the fields mentioned as values also?

In the parallel job the inputs to the Change Capture stage need not only to be sorted identically on the comparison keys but also hash partitioned identically on the comparison keys. Have you ensured that this is the case? Change Capture stage will report whether the second input row is an edit of ...

Hi, I have a question about how change capture works. Does change capture compare rows in the order they are located on the file, or does it look if that row exists anywhere in the file ? let me explain ... I have 2 versions of the same job ..... one is a server job and one is a parallel job ( they ...

I am trying to import a seqential file created in a server job with Fixed width columns to a parallel job. I have specified its a fixed width file and used the same metadata. The file created in the server job has 17 columns where 4 of them are "DECIMAL(17,3)" fields (Length 17, Scale 3). ...

If you are using a transformer in the job... why not use a substring or a right function ?

I have requested access at yr website.

There are server and parallel jobs in the category. Yeah, I need to look at the jobs .... but I jus need to know if there is a temp fix for it . Thanx a ton !

Is there a way that I can clear logs of all jobs in under a category?. We have about 10 jobs which generate a hell of a log and they are run atleast 4 times everyday.

Is it possible to clear the logs of all jobs at once manually or set a time to clear them automatically ?


Thanx

@ Kumar I have the parallel transformer in the palette but we dont have the compiler for it or sumthin. (not quite sure abt the reason ) Modify stage work for me now, turns out the data I have has retained some quotes chars from the previous server job where I am getting the data from. Thanx for yr ...

The data I have dosent make sense .... I need to recheck it !

Thanx for the help guys !

"It doesn't work" is singularly helpful as diagnostic information. (That's why vets charge more than doctors.)[/quote] :oops: :lol: This is the error: APT_CombinedOperatorController,0: Un-handled conversion error on field "PROMO_ID " from source type "string[8]" to dest...