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;
}
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
New contributor
add a comment |
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
New contributor
add a comment |
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
New contributor
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
historical-unix
New contributor
New contributor
New contributor
asked 40 mins ago
user350635user350635
1
1
New contributor
New contributor
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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