DSXchange

It has been a few months since I've touched DS. From my experience, it is nearly impossible to create "warning free" jobs. Warnings just give you some valuable information. In this case, it is just telling you that your data may not be accurate after the aggregation due to your target bein...

I'm sorry, I haven't had any experience with SQL Server, but I thought that timestamp types have the following format:

YYYY-MM-DD HH:MM:SS

In your statement "1900-01-01 00:00:00" seems to be in the right format, but you are missing date portion in "20:01:01".

In your XML Input stage, what is your XPath Derivation in the Column propoerties? XPath Derivation is in last (right-most) item in the Column Properties.

Have you set the line terminator in the FTP stage to "none"?

It should be under Inputs|Property Tab, the 4th item down.

wow that is nasty. The number of combinations is outrageous. I was thinking a separate lookup for each combination but 462 lookups is too much. I am sorry, perhaps some of the other professionals would be able to help you with this. This may be possible using awk, but I dunno how good it would be pe...

I have a file with fields some of the fields of the file may contain "*" as values, then match with the remaining columns and retrieve the col8 from table. Do you know exactly which fields would contain the "*"? How many of those fields "could" contain "*"?

ok thanks guys!

I performed a search but could not find any information about sparse lookups in server edition. Does anyone know if it is possible? I know that PX has this option.

In DS SE, you can only do this if the reference is an ODBC stage. It's been a while since I have done it, but I believe that the Server Job Developer's guide has details on how to do it (look for "Multirow Lookup for Reference Inputs"). The easier way to do it would be an SQL User defined ...

How are you going to keep track of the number of times the job has run? Are you using command line to kick start the job? If you can pass the number of iterations as a parameter, then it would be easy to implement using job sequence triggers. I need a little more information about what you want to d...

Type Decimal fields will always has a byte for the sign and a byte for the decimal. So if you have Decimal[9,0] and it is a positive number your number will be like this: space+123456789+period So what you want to do is trim the space and period. Try Trim(Trim(DecimalToString(%num%,%option),'.'),' '...

Then environment variable needs to be passed down as a parameter of the job. So you have to have the enviroment variabled defined in job parameter definitions.

if you take out '#', you should be fine.

please refer to this post:

viewtopic.php?t=101880

did you check the post under Data Integration? There is an exact same topic and eventuall a link to Inmon with a nifty diagram.

ahh, that is sneaky, I highly recommend becoming a charter member. It's great and you get to see everything?