none
find the ETL for FactInternetSales?

    Question

  • Hi experts, where can I find the ETL that creates the below table?

    I am assuming there must be one ETL/SP/SSIS bringing/building this data from a transactional, right?

    SELECT TOP (1000) [ProductKey]
          ,[OrderDateKey]
          ,[DueDateKey]
          ,[ShipDateKey]
          ,[CustomerKey]
          ,[PromotionKey]
          ,[CurrencyKey]
          ,[SalesTerritoryKey]
          ,[SalesOrderNumber]
          ,[SalesOrderLineNumber]
          ,[RevisionNumber]
          ,[OrderQuantity]
          ,[UnitPrice]
          ,[ExtendedAmount]
          ,[UnitPriceDiscountPct]
          ,[DiscountAmount]
          ,[ProductStandardCost]
          ,[TotalProductCost]
          ,[SalesAmount]
          ,[TaxAmt]
          ,[Freight]
          ,[CarrierTrackingNumber]
          ,[CustomerPONumber]
          ,[OrderDate]
          ,[DueDate]
          ,[ShipDate]
      FROM [AdventureWorksDW2012].[dbo].[FactInternetSales]

    jeudi 26 avril 2018 10:58

Toutes les réponses