Preceding load

[#1]

Hi all ,can any one explain how preceding load works ,and what is advantages of it with syntax,,

[Anonymous]

Yep, and especially comes in handy when doing transformations upon transformations on fields. It will in a lot of cases save you from having to do tmp tables and drop statements, and it will save you from very long nested transforming statements.

[#3]

Ok,thanks

[#4]

LOAD ProductKey,

    OrderDateKey,

   year( DueDateKey) as Yeardue,

TotalProductCost,

    sum(SalesAmount) as Totalsales,

SQL SELECT *

FROM AdventureWorksDW.dbo.FactInternetSales;

without unchecking preceding load iam getin same result so  please eplain,,

[stevedark]

Hi there,

You may want to see this blog post on the use of Preceding Load: http://bit.ly/1pHv56x

Steve