Hi,I am new to SQL Server PDW, I have a requirement to load a text file into PDW through dwloader.exe. The destination PDW server name is like "10.120.263.154,17005".When I am trying to connect to this server through dwloader.exe command line utility, i am getting an error like "No such...

SQL

SQL-Server-2008R2

DWH

How to capture technical Metadata from SSIS

30 Nov 2014 by SandraSH

Dears, currently i'm working on an ETL project using Sql Server Integration service (SSIS) and i want to capture the metadata like (the source table, the transformation occurred ,the destination ) how can i access those metadata , i know there are a system variables like the package Id ,and...

Data warehouse: Orders, Sales and Revenue facts

25 Jan 2016 by Purna Chandra Sasmal

Based on your data volume, you can decide.if it is less, you can create view on top of this and have the total sum of order, sale and revenue corresponding to dimensions.or, you can create tabular model.

Oracle Materialized Views under ETL Processes, an Opportunity Cost Approach

30 Jan 2018 by Member 11127135

Oracle materialized views under ETL processes

can I switch an olap cube to a relational Database

24 Feb 2015 by Member 11333067

I want to cross SEVERAL cubes, so I thought if I can switch olap to a relational database to make better use of the data ??

DWH

OLAP

Data warehouse: Orders, Sales and Revenue facts

25 Jan 2016 by Member 12286600

I need help on how to present or report from multiple fact tables:1. Orders (has all items that were ordered)1. Sales (has all sold items, spanning multiple years)2. Revenue (has revenue from items sold in current year)As you can see Sales amount Revenue amount.We have separated...