Skip to main content

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

628 Topics
M
Contributor
martin.d.larssonContributor
asked in Jobs & Executions
How to define schedules for each environment

We would like to be able to set specific schedules for our different environments. For example som execution packages could run on schedule in our QA environment during testing. And the TXDictionary should run on schedule in all environments.

413
Thomas Lind
Community Manager
2 years ago
J
Starter
j.romijnStarter
asked in Prepare
Table truncation options

Hi guys,Can someone elaborate the different options of table truncation? I can't really find it in the help or e-learning. We have set up an incremental load on a large table in the ODX, initially in simple mode. We found that the data after deployment & execution exists in the valid table and in the raw table, occupying twice the available storage of the original table size. We then disabled simple mode and checked the truncate raw table before transfer. I now still see some records (not all of them) in the raw table. I guess I'll have to check "Empty raw table after data cleansing" to completely empty the raw table after reloading, but I can't really grasp the difference between these options. 

2773
J
Starter
1 year ago
G
Contributor
gediminas.juskenasContributor
asked in Prepare
Converting int/char to date

Hello, I have a problem that i am struggling with. I have a table that contains field called [Period] and it stores month dates in following int format: 2201, 2202, 2203 which i need to translate to 2022-01-01, 2022-02-01, 2022-03-01 etc. to date format (always 1st day of month) The problem is i can convert the source format to date format in the view, but when i am trying to generate a table from that view, i always get an error that [Period] cannot be converted to date format. I have different options and nothing has worked as timextender always fails to convert to date format. Everything that failed on timextender, worked perfectly on MSSQL so i am not sure what is wrong. Thanks for your help

2066
G
Contributor
1 year ago

Badge winners

  • Innovator
    KCMThas earned the badge Innovator
  • Certified Solutions Architect
    dennishanssenhas earned the badge Certified Solutions Architect
  • Prepare Expert
    Roy Vhas earned the badge Prepare Expert
  • Deliver Expert
    rvgfoxhas earned the badge Deliver Expert
  • Prepare Expert
    rvgfoxhas earned the badge Prepare Expert
Show all badges
Terms and ConditionsCookie settings