DSXchange

Yes, SQL delete in a UV stage versus a reload of the file.

All right, thank you.

If I keep deleteing records daily, should I expect over time a degradation of performance that will eventually require a reload? I am trying to asses the maintenance impact of one method versus the other.
Thanks

Hello,
If I delete records from a hashed file does that significantly influence the file's performance? Is it better to unload/reload the entire file, filtering out the records I do not need?
Thanks

Greg,
I coded it as you suggested and it worked.
Thank you for your help.

I did not explain it correctly. I was referring to the 'out link' as the link that goes from the Row Generator Transformer to the UV stage. So, it would be the UV stage input link.

I will try the method you suggested, but can you see a reason why the SQL would not execute with my design?

Hello, my requirement is to delete specific records from a hashed file. The file has been created in a project. The file's layout is as follows: BUS_KEY SRC_SYS_ID CRC CREATE_EW_DTTM The first two columns are the key columns. The first three columns are VARCHAR. The fourth column is Timestamp. I rea...

All right, thank you both.

Craig,
I still do not see it. Here is what I have from the index list on string 'dsget':

DSGetJobInfo
DSGetLinkInfo
DSGetLogEntry
DSGetLogSummary
DSGetNewestLogId
DSGetParamInfo
DSGetProjectInfo
DSGetStageInfo
etc..

This is 7.5.1 help.

Hello,

I saw few posts mentioning function DSGetLogDetail but I could not find it in the 7.5.1a manuals I have available. I tried also the client help pages to no avail. Could you please post its syntax or let me know where to find it?

Thanks

We are trying to connect Ascential DS 7.5 (which is on UNIX) with MS Analysis Server (which is on Windows) to get Cube data. Ascential is on a Unix box and MS Analysis Server is on Windows. 1. What ODBC driver can we use to make this connection? 2. Is there support for JDBC drivers in DS? Any input ...