Viewing 15 posts - 16 through 30 (of 1,838 total)
+1 (well, really +1000) on Phils comments. this is very poor form, like when you used to use modal dialogs in VB6, or flashing & scrolling text in the browser...
January 8, 2016 at 10:43 am
if you want to pre-prep in Excel, then just use
=IF(ISBLANK(F10), G9, F10)
for Column G, starting in row 10. Then just copy down to all rows in...
December 4, 2015 at 11:29 am
Am assuming you tried this.
I didn't notice whether folks mentioned it, but I would *always* aim to use an OLE DB driver over an ADO.net driver.
This guy seemed to make...
November 15, 2015 at 4:15 pm
Have you got all the OLE DB drivers installed on the server you're running this on? When it says EXCEL is not valid, I'd be concerned that I don't have...
October 29, 2015 at 1:58 pm
doesn't require anything local other than the driver (whether that be cdata or dbamp or whoever). these interface with the API, but that's in the cloud.
August 19, 2015 at 9:19 am
As I understand Eric shows how to connect to a standalone Salesforce database server.
Is there a way to create a linked server to "Salesforce as a Service" database at
August 18, 2015 at 10:13 am
Absolutely it lets you do that. *But* it also works effectively like an OLEDB driver, so you can easily create a linked server (or multiples, one for PROd, sandboxes etc)...
August 18, 2015 at 7:44 am
So basically the 'article' is an install guide/set up instructions for a very specific driver? We use DBAmp for the same purpose and the provide a nice guide but I...
August 18, 2015 at 6:45 am
Joining fact with dimension tables using sequential integer based surrogate keys is a widely used data warehousing practice.
It absolutely is, and I would use it 9 out of 10 times....
July 9, 2015 at 3:29 pm
Your last reply seems to suggest support for both approaches (the pain of a lookup would make using natural (GUID) keys more appealing), but then you seem concerned about the...
July 9, 2015 at 11:41 am
sortof (ok, I mean, I don't think I agree 😀 )
That "reference" table you refer to, is the dimension table. And the process of checking for existance (with a...
July 8, 2015 at 2:11 pm
The SF GUIDs are a max of 18, so CHAR(18) although I've seen different systems (DBAmp OLE DB driver for one) declare them as NCHAR(18). You will almost certainly want...
July 7, 2015 at 3:52 pm
Would appear you'd need to create some outer loop (maybe using SSIS to do this?) -you can't join a query of the catalogs and cube_schemas.
June 30, 2015 at 2:38 pm
ahh but David, Surname is in table2 not table1. How would we get the value from table2 instead? :hehe:
June 12, 2015 at 7:00 am
Create one (or more) user hierarchies in the dimension.
June 12, 2015 at 5:10 am
Viewing 15 posts - 16 through 30 (of 1,838 total)