<commit_before><?xml version="1.0" encoding="UTF-8"?>
<Graph name="Export FS_PMT_DOC_LOC_T" revision="1.0">
  <Global>
    <Property fileURL="workspace.prm" id="WorkspaceParameters" />
    <Connection dbConfig="${DATABASE}" id="TargetDB" type="JDBC" />
    <Metadata id="OutputFileFormat" fileURL="${FORMAT_DIR}/fp_dv_doc_loc_t.fmt.xml" />
  </Global>
   <Phase number="0">
     <Node id="DATABASE_RUN"
           type="DB_EXECUTE"
           dbConnection="TargetDB"
           sqlQuery="TRUNCATE TABLE FS_PMT_DOC_LOC_T" />
   </Phase>
   <Phase number="1">
    <Node id="INPUT" type="DATA_READER" skipLeadingBlanks="false" fileURL="${DATA_DIR}/fs_pmt_doc_loc_t.txt" skipFirstLine="true" dataPolicy="strict" charset="UTF-8" quotedStrings="false" trim="false" treatMultipleDelimitersAsOne="false" />
    <Edge fromNode="INPUT:0" toNode="FIX_DELIM:0" id="INPUT_TO_FIX_DELIM" metadata="OutputFileFormat" />
    <Node id="FIX_DELIM" type="REFORMAT">
      <attr name="transform"><![CDATA[
//#TL
    function transform() {
        $0.pmt_doc_loc_cd := replace(nvl($pmt_doc_loc_cd, ""), "~!~", "|" );
        $0.obj_id := replace(nvl($obj_id, ""), "~!~", "|" );
        $0.ver_nbr := $ver_nbr;
        $0.pmt_doc_loc_nm := replace(nvl($pmt_doc_loc_nm, ""), "~!~", "|" );
        $0.pmt_doc_loc_addr := replace(nvl($pmt_doc_loc_addr, ""), "~!~", "|" );
        $0.row_actv_ind := replace(nvl($row_actv_ind, ""), "~!~", "|" );
   }
      ]]></attr>
    </Node>
    <Edge fromNode="FIX_DELIM:0" toNode="DB_OUTPUT:0" id="TO_OUTPUT"  metadata="OutputFileFormat" />
    <Node id="DB_OUTPUT" type="KUL_DB_OUTPUT_TABLE" metadata="OutputFileFormat" dbConnection="TargetDB" dbTable="fs_pmt_doc_loc_t" batchMode="true" errorAction="ROLLBACK" />
  </Phase>
</Graph>
  
  
<commit_msg>fix false reference to old fp_dv version of table in the fs_pmt_doc_loc_t.import.grf.xml file<commit_after><?xml version="1.0" encoding="UTF-8"?>
<Graph name="Export FS_PMT_DOC_LOC_T" revision="1.0">
  <Global>
    <Property fileURL="workspace.prm" id="WorkspaceParameters" />
    <Connection dbConfig="${DATABASE}" id="TargetDB" type="JDBC" />
    <Metadata id="OutputFileFormat" fileURL="${FORMAT_DIR}/fs_pmt_doc_loc_t.fmt.xml" />
  </Global>
   <Phase number="0">
     <Node id="DATABASE_RUN"
           type="DB_EXECUTE"
           dbConnection="TargetDB"
           sqlQuery="TRUNCATE TABLE FS_PMT_DOC_LOC_T" />
   </Phase>
   <Phase number="1">
    <Node id="INPUT" type="DATA_READER" skipLeadingBlanks="false" fileURL="${DATA_DIR}/fs_pmt_doc_loc_t.txt" skipFirstLine="true" dataPolicy="strict" charset="UTF-8" quotedStrings="false" trim="false" treatMultipleDelimitersAsOne="false" />
    <Edge fromNode="INPUT:0" toNode="FIX_DELIM:0" id="INPUT_TO_FIX_DELIM" metadata="OutputFileFormat" />
    <Node id="FIX_DELIM" type="REFORMAT">
      <attr name="transform"><![CDATA[
//#TL
    function transform() {
        $0.pmt_doc_loc_cd := replace(nvl($pmt_doc_loc_cd, ""), "~!~", "|" );
        $0.obj_id := replace(nvl($obj_id, ""), "~!~", "|" );
        $0.ver_nbr := $ver_nbr;
        $0.pmt_doc_loc_nm := replace(nvl($pmt_doc_loc_nm, ""), "~!~", "|" );
        $0.pmt_doc_loc_addr := replace(nvl($pmt_doc_loc_addr, ""), "~!~", "|" );
        $0.row_actv_ind := replace(nvl($row_actv_ind, ""), "~!~", "|" );
   }
      ]]></attr>
    </Node>
    <Edge fromNode="FIX_DELIM:0" toNode="DB_OUTPUT:0" id="TO_OUTPUT"  metadata="OutputFileFormat" />
    <Node id="DB_OUTPUT" type="KUL_DB_OUTPUT_TABLE" metadata="OutputFileFormat" dbConnection="TargetDB" dbTable="fs_pmt_doc_loc_t" batchMode="true" errorAction="ROLLBACK" />
  </Phase>
</Graph>
  
  

{'fraction_non_alphanumeric': 0.1967893717132577, 'fraction_numerical': 0.00996401882092444, 'mean_word_length': 4.594427244582043, 'pattern_counts': {'":': 0, '<': 47, '<?xml version=': 2, '>': 47, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 5}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7321045', 'n_tokens_mistral': 1412, 'n_tokens_neox': 1377, 'n_words': 180}