DSXchange

I have a biz rule where I multiply col1 of type dec15,8 with dec20,4 and my target type is dec20,4. To avoid any possible DS warnings do I implicitly convert anything?

Im trying to use IsValid function. The dev guide says the arguments for usage is type(string) format (string). My input column type is - string and output column type is - string But before I moved the data over to another stage I want to check if the input column type could be converted to a date o...

How to check if StringtoDate converts successfully? The format being "yyyy-dd-mm". Thanks

What syntax do i throw in a filter stage while looking for a NULL value in a specific column.
IsNull(Col)
OR
??
Thx

Im creating a surrogate key column whose datatype is Bigint. I then move this over to a target column whose type is also BigInt. In the warning message is see- Process_Run_Id: When checking operator: When binding output interface field "Process_Run_ID" to field "Process_Run_ID": ...

Its a bug with unicode patch. I had to delete unicode description from extended and send the job over to tech support.

I changed the column lengths to be equal on source and target side. I still get the same error - APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver]String data, right truncation [DataDirect][ODBC SQL Server Driver]String data, right truncation [DataDirect][ODBC SQL Server Driver]S...

RCP is off.

I have certain moves from varchar(60) to varchar(40) and some char(30) to char(40) and I have applied left(colname,40) and left(colname,30). It still fails with the message below on SQl server 2005 in DS- APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver]String data, right trunca...

My job aborts even Im trimming varchar60 to 1,40 when writing to target type varchar40.
Do I use something like varchar0 convert function for this too as best practice?

We had issues in moving data from char to varchar fields. I have trimmed all char before writing to varchar. Is there anything else I should be looking at? thx

I used @NULL in Server. What is the syntax in PX for same to default to Null.
Im currently defaulting by '' but that doesn't seem right to me. Thanks

I have 2 columns from 2 separate sources. 1. Row count from aggr stage. 2. Process_id from surrogate key gen stage. At any given point of time there would be only 1 value coming in from each of these stages. I need to combine these 2 into one row output. How could I achieve that? I tried lookup but ...

Never mind! I figured it out myself! Select aggr type to "Count rows" in the stage.

Im trying to get a best method. Looks like row count is not possible through aggr stage. Is there another way?