I have tables of assets(say 3 assets) which has following columns assetID status updated_date Now every week there will be a change in status of the few assets. So only changed ones will be populated into this table. So if…
I have data stored in postgreSQL as data source and I want to load dimensions and fact tables of the clickhouse datawarehouse , I am new to clickhouse and used to use traditional integration tools like Talend and Microsoft SSIS…
My goal To calculate the sum of components sold as part of their parent assemblies. I'm sure this must be a common use case, but I haven't yet found documentation that leads to the result I'm looking for. Background I'm…
User when access BOBJ tomcat URL the AD SSO works without any issues, when the user tries to access the Apache load balancer, then we get the Request entity too large error message. This is happening for few of the…
In order to conduct a Market Basket Analysis on the sales data in magento, i need to retrieve the products that are included in each invoice from magento. So far this is what i got. SELECT tblInvoice.increment_id AS orderId, tblLine.product_id…