Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Business and Economics Interviews:Account Manager AssistantAccountantAccounting ClerkAccounts ExecutiveAccounts OfficerAccounts Receivable (AR)AI AlgorithmsBPELBudgetingBusiness Development AssociateBusiness Development OfficerBusiness Development ResearcherBusiness Executive DevelopmentBusiness RatiosBusiness StrategyCA (Chartered Accountants)Change managementChief executive officer (CEO)Company Affairs (CS)Competitive StrategyCooperation SkillsCorporate StrategyCSCustomer ExperienceCustomer ServiceDeposit AccountEcommerce Customer Support ExecutiveEcommerce ManagerEconomicsExecutive International BusinessFinancialFixed AssetsGeneral AccountingGeneral LedgerGood SupervisorHospitality AccountingICWAImport Export SpecialistInsuranceIntegrated AuditsInventory AccountingInventory planning and controlManager Business UnitMerchandiserMergers & AcquisitionsNonprofit AccountingOrganizational IssuesOrganizational SkillsPayables ManagementPayroll ManagementPersonal AccountsPersonal Business AdviserPetty CashPrivate EquityProbation OfficerPublic relationsPurchase ExecutivePurchase PlannerPurchasing ManagerPurchasing OfficerQuality AuditsQuality MeasuresResearcher TraineeResponsibilityRetailRetaining Good EmployeesSecretary Accounts OfficerSenior Tax OfficerStrategy MethodsSuccessful StrategySweep AccountsTAX AccountantTaxationTransactional AccountsUser AccountWork Pressure
Copyright © 2018. All Rights Reserved
Business Development Officer Interview Question:
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Submitted by: AdministratorCartesian product is getting incorrect results.
for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.
ex:-
we have customer,orders,loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.
Submitted by:
for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.
ex:-
we have customer,orders,loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.
Submitted by:
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.