DSXchange

ray.wurlod wrote:No such configuration parameter of which I'm aware.

This is so difficult to accept that we have to do conversion from Unicode to Ascii by modify or transformer before we use them in the join.

I guess people worked on teradata should have experienced this issue...

You could convert the Unicode data to non-Unicode in an upstream Modify stage. Add a NOWARN specification. But what's wrong with performing a Unicode comparison? Thanks for your reply Ray I thought we could have small little configuration parameter in the datastage, so change would be only in that ...

Here is our job design Teradata Enterprise -------> | ------------------------------------| Change Capture ------> Output Sequential File----------------> | Here data from Teradata Enterprise and Sequential file are identical, but CDC gives most of the record as new records. "main_program: When...

We have tested the null comparison using CDC and it just works fine.

I guess one of the data is actually not having a null value, so this CDC returns as change. Please see the internal representation of the field, which is having a problem to identify the real issue.

Hi, How can I pass the Invocation ID to the job with the file name Ext_ABC.ds ABC is my invocation ID for the Dimension jobs. Thanks Suresh Suresh i had similar experience here is what i have done in that case. For each dimension i created two sequence as follows I created one sequence, which is no...

I change the NLS setting on the CFF stage and also the job level but without success. When I changed it on the job level all field were unreadable. The format of the field coming in on the CFF stage is CHARACTER 26 scale 6, could this need to be adjusted or have any impact on the results. Thanks, S...

For testing purpose, I am only dumping the data to a text file. For all the PIC S9(9) USAGE COMP columns, What should be my column type and lenght definition (parallel job) at the source? If I put varchar(4), the target doesn't show any value? Try to use the "Import-->COBOL File Definations&qu...

thamark, I have my input and output columns defined as Varchar(100). So that's not what is causing it. I even tried Trim(Trim(InCol), 'x','B') But it still returns: AAAAAAAxxxxxBBBBBBBBBBxxxxxxxx Whale. Then you can verify to see, if you have some un-printable character at end of the string.

I_Server_Whale wrote: Whale.

I guess this is problem due to the Data Type of the column.

Following function should give you correct answer, if that is the case

Trim(Trim(Column), 'x','B')

I noticed this kind of behavior if the input column is character data type column , by which length of field is not exactly same as field length defined and it pads spaces at the end. Last example works fine since i am triming trailing spaces and then trimming again... Means Col1 Char 2000 Col1 ='xx...

Hi all, thanks for the replies All the other dimensions have the same design. The size of the data is more/less same in each dimension. so we are clueless :oops: You could try more option to identify where exactly you have problem. 1) Remove lookup and do straingt DB Update/Insert(This change is fr...

Try writing into sequential file instead of database Insert/Update(Upsert), since upsert is costlier operation to do.

If this method runs in minutes then you can try to identify operation type and do it using individual stage.

This may not be what exactly you are looking for, but just an alternative.

There is a option in the Datastage Director --> View --> Show Categories.

Disable this option and sort the entries by started timestamp column, so it would show everything in order of execution....

Did you try doing the conversion using a Modify stage? Was it a Transformer stage or a BASIC Transformer stage? A BASIC Transformer stage has a limit to the precision that can be represented, whic ... Ray I am using the Transformer stage not a BASIC Transforment stage. I tried this options using th...

Try using square brackets. DB_AMT:DECIMAL[18,2] = decimal_from_dfloat(DB_AMT) I did the conversion using the transformer, but the output is not consistent accross the runs see the output as follows. Run 1 Col1(count), Col2(sum), Col3(sum) 38237290, 0023089122060890.50,-0023090433853699.81 Run 2 Col...