Gerry Mullin
- Total activity 32
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 1
- Subscriptions 16
Activity overview
Latest activity by Gerry Mullin-
Gerry Mullin commented,
This error looks like the temp file that the prior node had written out is no longer being found in the temp directory. I would presume you're seeing a green pin, but if you click on it, you can't ...
-
Gerry Mullin commented,
Hi Mario, I have a custom node that will help you. I'll send it to you in a separate email.
-
Gerry Mullin commented,
Have you tried using JDBC Store node in place of the JDBC Execute? On the Option tab you can set the LoadMethod to Optimized with a CommitFrequency of 1000. I've seen dramatic increases speed rathe...
-
Gerry Mullin commented,
Hey Mike, presuming that the field Original is already of type date you can just do this in a Calculated Fields node. The same would work in a Transform too. Same can be said for extracting year or...
-
Gerry Mullin commented,
I can think of a couple of ways to at least help you out, but it's not exactly what you're asking. Create a library node with the function in it and just use this where needed. This is a little ...
-
Gerry Mullin commented,
I put this in a Calculate Fields node (connected to a Create Data node). You can use this in a Transform also. Note you'll have to explicitly handle Null values. dueDate + datetime.timedelta(days=3...
-
Gerry Mullin commented,
You can use timedelta in a Transform node and add 30 days to the date. https://docs.python.org/2/library/datetime.html#datetime.timedelta
-
Gerry Mullin commented,
No you only need to add that entry in cust.prop. Take a look at the example in the documentation. You will have to restart and rerun your data flow to get temp files written to your new location.
-
Gerry Mullin commented,
This might not be the most elegant solution. But I'm going to suggest reading in the BRD all the time, then dropping it if it's over 7 days and proceeding with the query. On the flip side of that i...
-
Gerry Mullin commented,
You can use the ls.brain.tempDir parameter to point to some other location. You should see it in your <DSA_Install_Dir>/conf/site.prop file.