DSXchange

Just try using Teradata Multiload stage. It may work for you. I have 2 purposes for this posting. One is to let people know about an issue we are seeing in case they are encountering the same issue. The second is to glean whatever information is available about this from others that have already wor...

May be your typecasting is failing due to invalid data being passed for date conversion. Before using typecasting function, use IsValid and do the conversion only if this function is returning true. PX makes that kind of debugging difficult. Do you know which particular conversion is causing it? If ...

hamzaqk, Just wanted to clarify on the temporary table creation mechanism. Will it not be create SET TABLE orch_workxxx as select * from source with NO data Instead of create SET TABLE orch_workxxx as select * from source with data Thanks it will ignore the values when you use the enterprise stage. ...

Cool .. It worked !!! Thanks.

Not working

I already did that. I had set TTTTT in default for a CHAR(5) column. It's not working.

I am processing MF (EBCDIC) data. There are some CHAR columns having X'00' value (low value) at MF. We are doing NDM and processing through DS job. I want to intialize with "" if column encounters this low value. (1) How to initialize such columns with "" in Sequential Reader whi...

Maveric solution will work based on the assumption that column data type is CHAR not VARCHAR.

Create a small dummy job to read the same dataset instead of reading from Data Set Management tool to check how many records are being read.

Create a small dummy job to read the same dataset instead of reading from Data Set Management tool.

Put Copy after reading the data. One output of copy should have only key columns for Aggregator stage. Aggregator will give count of duplicate records along with key columns. Use second output of Copy as an input (left link) to Join alongwith Aggregator output. The Join output should be used as an i...

Ray - Thanks a lot for your attention. We do have these 80 columns in available (other process is calculating them). These String1 and String2 is formed in the Transformer based on the predefined categories in order to address different conditions. Examples of some conditions - (1) Perform different...

I have following 2 strings columns coming into the transformer - String1 = "Qty1,Score1|Qty2,Score2|Qty3,Score3|.......|Qty20,Score20" String2 = "Qty1,Score1|Qty2,Score2|Qty3,Score3|.......|Qty20,Score20" I need to find out if there is a tie between Qty across these two String Co...