Seems like Rank is being applied after the Filter. Try storing Rank as a physical database object like a Temp table and select using a join.

Mathematically what you are saying makes sense - but check for the compatiblity of the two functions TIMESTAMPDIFF and SQL_TSI_DAY. I think the first one expects a full timestamp, whereas the second only seems to provide the DAY without the rest of the hours, minutes, seconds?

In ETL Engineering, this is usually accomplished from Import/Export of flat files between heterogeneous environments as the risk of data loss is higher when compared to the probability in each environment.

If data is not rendering after you have checked all correct setup, ask you DBA if there is any physical layer constraints that is enforcing such rules.

If data is not rendering after you have done everthing you can, check with you DBA to see if there are any DB level GRANTS that need to be executed. Sometimes, the DB layer has additional levels of security.

There are many ways to refresh a DEV database from PROD. It is usually a DBA Operations task as it encompasses company data policies from CIO office.

As a Best-Practice, as you are bringing data into your 'own' DW I presume you want an Enterprise Data solution. For this, ensuring high DQ with regular metadata matching would improve operational efficiency at your company.

This is an excellent question to explain the importance of IFRS. Now, Oracle has provided mechanisms to calculate Depreciation of Current Assets as per Asset Configuration, like straight line (which is included in IFRS) and some others like Accelarated Cost Recovery (which are not included in IFRS). Customers could easily…

Hi, You should really use one of the standard reports to collect this information. Writing ad-hoc queries is not suitable, as further patches etc., would corrupt your reported data. From the symptoms, it seems like a Data Quality issue, where the current state is significantly different to any assumed state during…

Dear Jose, VAT/GST functionally treated separately to the actual journal entry for the purchasing transaction. For example, if you bought a $100 product and paid 10% GST of $10, the $100 and $10 should be recorded separately. The Tax Office usually allows for running calculation of GST/VAT paid and collected, so a…

Hi Dinesh, I understand your problem, however, usually a functional value such as running balances do not have any last_updated_date. The reason is that it is expected to be different every time you run the query, so the value should really be the date and time you are extracting this data - for your purposes. Cheers!…