<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://truxwiki.com/index.php?action=history&amp;feed=atom&amp;title=ETL_Application_Modes</id>
	<title>ETL Application Modes - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://truxwiki.com/index.php?action=history&amp;feed=atom&amp;title=ETL_Application_Modes"/>
	<link rel="alternate" type="text/html" href="https://truxwiki.com/index.php?title=ETL_Application_Modes&amp;action=history"/>
	<updated>2026-09-09T16:11:09Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.34.1</generator>
	<entry>
		<id>https://truxwiki.com/index.php?title=ETL_Application_Modes&amp;diff=3363&amp;oldid=prev</id>
		<title>Sam at 15:12, 22 January 2021</title>
		<link rel="alternate" type="text/html" href="https://truxwiki.com/index.php?title=ETL_Application_Modes&amp;diff=3363&amp;oldid=prev"/>
		<updated>2021-01-22T15:12:49Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;Revision as of 15:12, 22 January 2021&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l40&quot; &gt;Line 40:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 40:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_EXCLUSIVE_ROUTING&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_EXCLUSIVE_ROUTING&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| style=&amp;quot;text-align:center;&amp;quot; | 128&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| style=&amp;quot;text-align:center;&amp;quot; | 128&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| Any attempt to alter the &amp;lt;code&amp;gt;[&lt;del class=&quot;diffchange diffchange-inline&quot;&gt;ETLRoutes&lt;/del&gt;]&amp;lt;/code&amp;gt; table to have different file types routed to this ETL will be overwritten.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| Any attempt to alter the &amp;lt;code&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;&amp;gt;&amp;lt;nowiki&lt;/ins&gt;&amp;gt;[&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;&amp;lt;/nowiki&amp;gt;[[ETLRoute Table|ETLRoute]]&amp;lt;nowiki&amp;gt;&lt;/ins&gt;]&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;&amp;lt;/nowiki&amp;gt;&lt;/ins&gt;&amp;lt;/code&amp;gt; table to have different file types routed to this ETL will be overwritten.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;|-&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;|-&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_SEND_PINGS&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt; &lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_SEND_PINGS&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Sam</name></author>
		
	</entry>
	<entry>
		<id>https://truxwiki.com/index.php?title=ETL_Application_Modes&amp;diff=3358&amp;oldid=prev</id>
		<title>Sam: Created page with &quot;These values for the bits used in the ETL mode bit-flag field.  {| class=&quot;wikitable&quot; ! Name ! Value ! Meaning |- | &lt;code&gt;ETL_APPLICATION_MODE_NORMAL&lt;/code&gt; | style=&quot;text-align...&quot;</title>
		<link rel="alternate" type="text/html" href="https://truxwiki.com/index.php?title=ETL_Application_Modes&amp;diff=3358&amp;oldid=prev"/>
		<updated>2021-01-21T20:13:22Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;These values for the bits used in the ETL mode bit-flag field.  {| class=&amp;quot;wikitable&amp;quot; ! Name ! Value ! Meaning |- | &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_NORMAL&amp;lt;/code&amp;gt; | style=&amp;quot;text-align...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;These values for the bits used in the ETL mode bit-flag field.&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
! Name&lt;br /&gt;
! Value&lt;br /&gt;
! Meaning&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_NORMAL&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 0&lt;br /&gt;
| No special ways to run this ETL.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_LOG_MESSAGES&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 1&lt;br /&gt;
| Very dangerous option that will dump every message that the ETL receives.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_LOW_MESSAGE_VOLUME&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 2&lt;br /&gt;
| This tells Truxton that you are an ETL that won't receive very many messages.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_NO_DATABASE&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 4&lt;br /&gt;
| You are an ETL that doesn't write to the database.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_MINIMIZE_DATABASE&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 8&lt;br /&gt;
| You are an ETL that rarely writes to the database.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_NO_HASHSETS&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 16&lt;br /&gt;
| You are an ETL that doesn't deal in files so don't waste resources loading the hash sets.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_EXIT_AFTER_INITIALIZE&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 32&lt;br /&gt;
| You are an ETL that will perform initialization then exit immediately.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_DONT_CREATE_QUEUE&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 64&lt;br /&gt;
| You are an ETL that won't be using the [[Message Bus]].&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_EXCLUSIVE_ROUTING&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 128&lt;br /&gt;
| Any attempt to alter the &amp;lt;code&amp;gt;[ETLRoutes]&amp;lt;/code&amp;gt; table to have different file types routed to this ETL will be overwritten.&lt;br /&gt;
|-&lt;br /&gt;
| &amp;lt;code&amp;gt;ETL_APPLICATION_MODE_SEND_PINGS&amp;lt;/code&amp;gt;&lt;br /&gt;
| style=&amp;quot;text-align:center;&amp;quot; | 256&lt;br /&gt;
| Have the ETL send periodic [[Message Bus Messages#Ping|Ping]] messages to [[Les]] letting him know you are still processing a file&lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Sam</name></author>
		
	</entry>
</feed>