DSXchange

Hi Ray,

I guess, when we are reading decimal values from teradata, the 0s are truncated
ex 1.5 instead of 1.50

Is there any way we can preserve the 0s.

When loading a decimal column values to a sequential file, the results are as expected 000001.50 000002.50 etc and when the same source data is loaded into an XML file , the 0s are trimed 1.5 2.5 Is there a env variable we can use to avoid this happening, like in oracle we can use preserve_blanks. D...

When loading a decimal column values to a sequential file, the results are as expected 000001.50 000002.50 etc and when the same source data is loaded into an XML file , the 0s are trimed 1.5 2.5 Is there a env variable we can use to avoid this happening, like in oracle we can use preserve_blanks. D...

Thanks for the detailed posting, we are trying to read it from seq file , but it does not show any data and aborts with XML_Input_1,0: Error: XSLT error: xsl:variable has an illegal attribute, style tree node: xsl:variable (, line 5, column 43) XML source column not found. Column Name = "EXTRAC...

Hi Craig,


I am trying to locate the folder stage in the pallete and can not find it. Is it a plug-in (which is hard to believe). I did go to customize the pallete and search in all stage types for parallel.

We are on 7.5.1A, UNIX.

Thanks,

What do you mean by created? so these are created at the project level?

Hi, If I have a simple command in the open or close command in the TDE stage , the job aborts with :Parallel job reports failure (code 139): Insert into table1 (abc) values ('drf') The main query has different table, select name1 from customer I tried to use the insert command in the ODBC EE stage a...

Hi Guys, We are on 7.5.1.A and I have run into the same issue and when I try to set the env variables below , I can not find them in our project ! Do we have to folow specific steps to add them to the project? APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table] APT_TERA_SYNC_DATABASE = [db ...

Hi Ray,
The option you have mentioned is sufficient for us now I believe, thanks for it, its a relief.

All we are looking for is the job details like the stages and the sql in the source stages if we can get to it.

Thanks

Hi Ray,
We do not have MetaStage, so is there no way I can get the job documentation or use the reporting assistant?

We are on DS 7.5.1.A EE.


Thanks,

I got it, I changed the source column type to Decimal and the function works, thanks Ray!

Hi Ray, I have used ME_TGT:int64=int64_from_decimal [trunc_zero] (ME_LOW) ME_TGT:integer=int32_from_decimal [trunc_zero] (ME_LOW) ME_TGT=int64_from_decimal [trunc_zero] (ME_LOW) My source column is Real (40.8) and my target column is integer(ME_TGT). The job aborts saying operator conversion not pos...

Would that round it off or just give the number before the decimal, becasue if it is 11.98 , still we need only 11.

I do not have the access to DS now, will try your idea Ray.

Thanks a bunch.

Hi,
If I have the source as 11.34 I need only the numbers before the decimal, i.e. 11 .

Is there a stage I can use in EE instead of conventionally using the transformer?

Thanks,