needs to compare the Two Table for count with the Batch idHow did UNIX programs interact with each other,...

I caught several of my students plagiarizing. Could it be my fault as a teacher?

Why is the SNP putting so much emphasis on currency plans?

You look catfish vs You look like a catfish?

Can fracking help reduce CO2?

Power LED from 3.3V Power Pin without Resistor

Hang 20lb projector screen on Hardieplank

How could a planet have most of its water in the atmosphere?

How did Arya get back her dagger from Sansa?

How to reply this mail from potential PhD professor?

Historically, were women trained for obligatory wars? Or did they serve some other military function?

If Melisandre foresaw another character closing blue eyes, why did she follow Stannis?

If 1. e4 c6 is considered as a sound defense for black, why is 1. c3 so rare?

Why do computer-science majors learn calculus?

Has any spacecraft ever had the ability to directly communicate with civilian air traffic control?

How to assert on pagereference where the endpoint of pagereference is predefined

Is it the same airport YUL and YMQ in Canada?

Why was Germany not as successful as other Europeans in establishing overseas colonies?

Was the ancestor of SCSI, the SASI protocol, nothing more than a draft?

Does hiding behind 5-ft-wide cover give full cover?

A non-technological, repeating, phenomenon in the sky, holding its position in the sky for hours

How to scale a verbatim environment on a minipage?

What is the most remote airport from the center of the city it supposedly serves?

Why is Arya visibly scared in the library in S8E3?

Unexpected email from Yorkshire Bank



needs to compare the Two Table for count with the Batch id


How did UNIX programs interact with each other, before the invention of the pipe?What was the reason for lseek function to return file descriptors as long integer?Why was the dot (.) used as an alias for source & why don't other commands have shortcuts too?What were the original reason(s) for adding a “standard error” which is separate from “standard output”?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







-1















Good Morning



I have 2 environment(Both are in same database)
ist-Audit table and 2nd is DWH table,which is having the fact and dimension table.



i need to take the count for each table(Fact and dimension) from DWH,with the max batch id and compare the same count with Audit table count,which is having the same table (Fact and Dimension) with the max batch id.



After match count ,if matched record found,then needs to send an email and if not matched the record then also send the email



Please hep me ,how to write the script










share|improve this question







New contributor




user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



























    -1















    Good Morning



    I have 2 environment(Both are in same database)
    ist-Audit table and 2nd is DWH table,which is having the fact and dimension table.



    i need to take the count for each table(Fact and dimension) from DWH,with the max batch id and compare the same count with Audit table count,which is having the same table (Fact and Dimension) with the max batch id.



    After match count ,if matched record found,then needs to send an email and if not matched the record then also send the email



    Please hep me ,how to write the script










    share|improve this question







    New contributor




    user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      -1












      -1








      -1








      Good Morning



      I have 2 environment(Both are in same database)
      ist-Audit table and 2nd is DWH table,which is having the fact and dimension table.



      i need to take the count for each table(Fact and dimension) from DWH,with the max batch id and compare the same count with Audit table count,which is having the same table (Fact and Dimension) with the max batch id.



      After match count ,if matched record found,then needs to send an email and if not matched the record then also send the email



      Please hep me ,how to write the script










      share|improve this question







      New contributor




      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      Good Morning



      I have 2 environment(Both are in same database)
      ist-Audit table and 2nd is DWH table,which is having the fact and dimension table.



      i need to take the count for each table(Fact and dimension) from DWH,with the max batch id and compare the same count with Audit table count,which is having the same table (Fact and Dimension) with the max batch id.



      After match count ,if matched record found,then needs to send an email and if not matched the record then also send the email



      Please hep me ,how to write the script







      historical-unix






      share|improve this question







      New contributor




      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 40 mins ago









      user350635user350635

      1




      1




      New contributor




      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      user350635 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "106"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          user350635 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f516288%2fneeds-to-compare-the-two-table-for-count-with-the-batch-id%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          user350635 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          user350635 is a new contributor. Be nice, and check out our Code of Conduct.













          user350635 is a new contributor. Be nice, and check out our Code of Conduct.












          user350635 is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Unix & Linux Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f516288%2fneeds-to-compare-the-two-table-for-count-with-the-batch-id%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Taj Mahal Inhaltsverzeichnis Aufbau | Geschichte | 350-Jahr-Feier | Heutige Bedeutung | Siehe auch |...

          Baia Sprie Cuprins Etimologie | Istorie | Demografie | Politică și administrație | Arii naturale...

          Ciclooctatetraenă Vezi și | Bibliografie | Meniu de navigare637866text4148569-500570979m