We've implemented an ETL extraction out of SFDC using the "Change data capture" mechanism with SFDC as the Data Master (described ).  We do daily delta extractions using a filter on systemmodstamp and using the extract_all functionality of DataLoader CLI so we also include records with IsDeleted = true.   However we've noticed that sometimes deleted records are not returned as part of the ETL query result. In most cases they are, but sometimes they're not.   I suspect this has to do with many records being deleted at once, thus forcing a purge of the Recycle Bin within the day. This would mean that our end-of-day delta query will not pick up those deletes and the data will stay in our BICC system forever (as it will never be updated/deleted from SFDC again).  (Some background info on the recycle bin process , by the way)  So the question is:      is there any way that we can make the delta queries in this daily ETL extraction process 100% reliable?   Can I force deleted records to stay in the Recycle Bin for at least 24 hrs? Or should we do a full database dump each night? (I hope not..) We can't be the first company struggling with this?
I have the need to synchronize the data in certain Salesforce tables (user, account, opportunity, lead, task, contact, etc.) to a local database. For reasons that I won't go into here, I can't use the streaming API. I want to kick off a local process every X minutes that will:   Go through each of the tables on my list Insert any new records Update any existing records that were updated Delete any records locally that were deleted on the server (either deleted directly or indirectly (e.g. through a foreign key relationship, like when an account is deleted its associated tasks are deleted as well).   Can you please offer advice on what API's might be good to use here, and whether one stands out more than the others? Are there any specific design recommendations that might be useful for achieving this goal? Or is there really no practical difference between what REST vs SOAP can do?  It comes down to what is the easiest to maintain/implement? Is there some other route that might be beneficial to use (example: bulk data load to start out followed by outbound messaging tied to all of the objects in question to get updates/inserts/deletes)?   I am using C#/.net.
How to combine an SSD boot drive with a HDD data drive? Given  $$ y_n=\left(1+\frac{1}{n}\right)^{n+1}\hspace{-6mm},\qquad n \in \mathbb{N}, \quad n \geq 1. $$ Show that $\lbrace y_n \rbrace$ is a decreasing sequence. Anyone can help ?  I consider the ratio $\frac{y_{n+1}}{y_n}$ but I got stuck. I want to utilize beamer's \uncover command within ChemFig's reaction scheme environment, i.e.:  \schemestart     \chemname[-1ex]{\chemfig[][scale=1]{*5(-=(-=[:-60]O)-O-=)}}{Furfural}     \uncover&lt;2-&gt;{         \arrow(furfural--mf){-&gt;[*{0}HDO][]}         \chemname[-1ex]{\chemfig{*5(-=(-)-O-=)}}{2-Methylfuran}     } \schemestop   However, this results in numerous "undefined control sequence" errors.  Is there a way to use beamer's \uncover command within ChemFig?  Here is a full MWE:  \documentclass[10pt]{beamer} \usepackage{chemfig}  \begin{document}  \begin{frame} \frametitle{Stuff}  \schemestart     \chemname[0ex]{\chemfig[][scale=1]{*5(-=(-=[:-60]O)-O-=)}}{Furfural}     \uncover&lt;2-&gt;{         \arrow(furfural--mf){-&gt;[*{0}\textbf{HDO}][]}         \chemname[0ex]{\chemfig{*5(-=(-)-O-=)}}{2-Methylfuran}     } \schemestop  \end{frame}  \end{document} I saw this today, I checked in Mathematica and the integral comes out to $\pi$, but I have no idea how to solve it.     FREE Wi-Fi: The Wi-Fi password is the first $10$ digits of the answer.   $$\int_{-2}^2\left(x^3\cos\frac x2+\frac12\right)\sqrt{4-x^2}\ dx$$ Error message in my excel formula In PostgreSQL is the row ordering preserved in functions and CTEs? How to find hydrogen wave-functions? I have found the hydrogen wave functions and would now like to calculate the function that describes the orbitals so that I can plot this function and see how they look.  I don't know how I can do that and it is crazy how I cannot find anything on the subject on the internet as if there was no relation between the wave functions and the orbitals.  Could you please tell me what I need to do to get a function $r(\theta,\phi)$ out of my wave functions $\psi(r,\theta,\phi)$. Space war, humans recreated, grown from plants with an alien female supervisor This was a small hardback book I read in the UK in the late eighties. No memory of the cover.  Some kind of space war and a long lived alien female escapes the conflict in her starship, her side had lost.  An evil enemy that she needs to trap so she gets (I think) human  DNA from space dust and sets up on a habitable planet. The story then gets like episodic and looks at the world every couple of generations while she hides out there.  Plants bud on the world and people pop out from big seedpods, the population listens out for babies crying and rescue them.  There are legends of the 'Earth mother’ who secretly guides them to become high tech.   In reality she is creating attractive food bait for the bad aliens.  I think an early human and her are attracted to each other and she (maybe) gives him long life or (maybe) uses reincarnation to keep seeing him.  Edit:- the name 'Rimstalker' has just now popped up in my brain! How to find and delete files older than specific days in unix? Can't install libglew-dev because libcheese and libclutter don't have the required versions I'm getting the following error message when attempting to install libglew-dev,  Reading package lists... Done Building dependency tree        Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation:  The following packages have unmet dependencies:  libcheese-gtk23 : Depends: libclutter-gtk-1.0-0 (&gt;= 0.91.8) but it is not going to be installed                    Depends: libcogl15 (&gt;= 1.15.8) but it is not going to be installed  libcheese7 : Depends: libclutter-gst-2.0-0 (&gt;= 0.10.0) but it is not going to be installed               Depends: gstreamer1.0-clutter but it is not going to be installed  libclutter-1.0-0 : Depends: libcogl-pango15 (&gt;= 1.15.8) but it is not going to be installed                     Depends: libcogl15 (&gt;= 1.15.8) but it is not going to be installed E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.   All those packages are however apparently already installed.  I have tried all possible solutions in  post, without any luck. I have not added any PPAs. The version of ubuntu is 14.04.2.  I have looked at similar posts, and tried the following:  Running  dpkg --get-selections | grep hold   prints nothing.  sudo apt-get -oDebug::pkgProblemResolver=true install -f   Gives me nothing of interest, 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. How do I find out the user name and password for an existing account? MY site was created and maintained from a developer I cannot contact, and I need to know the username/password the developer used to access the site.  How can I achieve this? Multiplicative order and powers Let's consider two number $a$ and $b$ such as $gcd(a,b)=1$. Can you explain me intuitively why there exist $n&gt;0$ such as $a^{n} \equiv 1 \space (mod \space b)$  ? Why can't I find the Karin Kuruma? Troubleshooting "Windows cannot be installed to this disk. The selected disk has an MBR partition table" I recently bought a desktop computer with Windows 7 Home Premium x64 preloaded (OEM). I tried to install Windows 7 Ultimate x64 on this computer but I was presented with the following error message:     Windows cannot be installed to this disk. The selected disk has an MBR   partition table. On EFI systems, Windows can only be installed to GPT   disks.   The 1TB HDD on this computer has three partitions:   SYSTEM 100 NTFS - Healthy (System, Active Primary Partition)  OS (C:) 9148.04 GB NTFS - Healthy (Boot, Page File, Crash Dump, Primary Partition)  HP_RECOVERY (D:) 13.37 GB NTFS - Healthy (PrimarynPartition)   I'm trying to install a clean copy of Windows. Casting a function pointer to another type Let's say I have a function that accepts a void (*)(void*) function pointer for use as a callback:  void do_stuff(void (*callback_fp)(void*), void* callback_arg);   Now, if I have a function like this:  void my_callback_function(struct my_struct* arg);   Can I do this safely?  do_stuff((void (*)(void*)) &amp;my_callback_function, NULL);   I've looked at  and I've looked at some C standards which say you can cast to 'compatible function pointers', but I cannot find a definition of what 'compatible function pointer' means. I'm trying to figure out how to send all information that is normally identified in the /var/adm/message file on a Solaris system to a remote system. I found this , but I am not sure if this is the same issue.  On , I did some reformatting of the indentation in the code block to make it a bit more readable and it was  for peer review. A few minutes later, it appears the OP made an edit that added some additional code. It looks like my suggested edit was applied when the OP saved his/her edit, and it looks like he got the "credit" for the edit.  I'm not really concerned about the 2 rep points; I'm more curious why this happened and if this is a bug (or limitation) in the editing feature, or if this is known/intended behavior?  Note that this is not a suggested edit that's overridden by a concurrent edit: the recorded edit starts from the post-suggested edit state (and in fact can be identical to it, as in  ). “Have you seen...” or “Did you see...?” In the US, when people work together, they may look for a colleague or any person to say something or for any other reason, asking colleagues or other people this type of question:         Have you seen Michael?   (OR)        Did you see Michael?          Which is considered right if the question refers to an activity (in our case "see") during the day and not in the past in general? While watching  I noticed a very characteristic camera shot. At a scene where the main character, Wendy, sits in her room at the computer (watching the supposedly foretelling fotos), her sister talks to her from the outside (asking if she can have the camera/fotos). There is a certain camera shot, where on the left side a frontal close-up of Wendy's face is shown, while on the right side you see her sister standing in full height inside the open door.    This shot immediately struck me as being somehow characteristic and out of place and infused feelings to me of some kind of older Hitchcock or Brian De Palma thriller or something the like. I also think to remember of having seen this kind of shot or something similar used in , where Jessica Lange is shown in front of the dresser talking to Nick Nolte who stands in the door or father away.  I would like to know if this technique has a certain name or theory behind it and where its origins lie, or if there is any particular director or movie who made this famous. It may be even that Final Destination 3 uses this especially in reference to some director or movie. Are there any galois fields which consist of product of two primes, as in $\mathrm{GF}(2\cdot 3) = \mathrm{GF}(6)$?