hard20 pts · first answer countsdata-pipelinessqlreconciliation

No FX rate for Saturday orders

Orders in AED are converted to INR by joining a daily FX table on order_date. Rates are not published on weekends, so Saturday and Sunday orders get NULL INR amounts. What is the usual fix?

A.Drop weekend orders from the reportB.Use a rate of 1 whenever the rate is missingC.Use the latest rate on or before that dateD.Use the average rate of the whole year

Discussion 0

Join free to post in the discussion.

No FX rate for Saturday orders

Discussion 0

Related questions