Re: SKIP is not clear...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Because INSERT INTO takes an ordered list of columns. All columns from the
source have to be mapped by order into the insertion target. Since
Movies(CustomerID) does not exist, we use the terminology "SKIP" to indicate
columns from the source data query to ignore.

Therefore we say

INSERT INTO MyModel(Blah1, Blah2, Movies(SKIP, Movie)

To indicate to skip the column in the first position of the nested table in
the source data query

HTH

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
"sqlster" <nospam@xxxxxxxxxx> wrote in message
news:2DC709E5-B95A-44D2-A177-6D198D4ABBAA@xxxxxxxxxxxxxxxx
ziga,

This does not make sense. Why not just say SKIP CustomerID??


"ziga" wrote:

...(SKIP, Movie)... does not mean it skips attribute Movie but attribute
(foreign key) in front of attribute Movie. In this case it skips
attribute CustomerID.


Jamie wrote in the other post:
<Jamie>
In the nested table, you need to skip the foriegn key, not the data.
In the
model, the column CustomerID shouldn't exist in the nested table.

The corrected creation/training statements would be

CREATE MINING STRUCTURE myst
(
CustomerId long key,
moviedata table ( Movie text key)
)
;
ALTER MINING STRUCTURE myst
ADD MINING MODEL mym_ar
(
CustomerID,
MovieData predict ( Movie )
) using microsoft_association_rules
;
INSERT INTO MINING STRUCTURE myst
(
CustomerID ,
MovieData
( SKIP, Movie) )
SHAPE {
OPENQUERY(MovieDataDs,'SELECT CustomerID FROM CustomerMovies') }
APPEND
(
{OPENQUERY(MovieDataDs,'SELECT CustomerID,Movie FROM CustomerMovies')}
RELATE CustomerID TO CustomerID
) AS MovieData
</Jamie>

How is Movie a foreign key? Is this a foreign key in OLTP relational
sense?
I don't get it. In master query "select customerid from customermovies"
and
in child query we have "select customerid,movie from customermoives".
How can
movie be foreign key in this example?? What is the difference between
foreign
key and data here?? I understand that queries via openquery are
returning
data itself.

Please help and Thank you in advance..



.

Relevant Pages

  • Re: Web Cross-sell Application: Training structure problem
    ... INSERT INTO MINING STRUCTURE myst ... OPENQUERY(,'SELECT CustomerID FROM dbo.CustomerMovies')} ... moviedata table ... MovieData predict ...
    (microsoft.public.sqlserver.datamining)
  • Re: Best way to represent a many to many with optionality?
    ... DELETE Rules of the foreign key to enforce the above mentioned "business rules" without getting the "circularity/default" errors? ... SQL Server lets you specify any of the following rules to apply to either INSERT/UPDATE or DELETE: ... CustomerID bigint NOT NULL identity ... AddressTypeID tinyint NOT NULL ...
    (microsoft.public.sqlserver.programming)
  • Predictable column error
    ... CREATE MINING STRUCTURE myst ... CustomerId long key, ... MovieData predict ...
    (microsoft.public.sqlserver.datamining)
  • Re: SKIP is not clear...
    ... Why not just say SKIP CustomerID?? ... in front of attribute Movie. ... CREATE MINING STRUCTURE myst ... How is Movie a foreign key? ...
    (microsoft.public.sqlserver.datamining)
  • RE: SKIP is not clear...
    ... the column CustomerID shouldn't exist in the nested table. ... CREATE MINING STRUCTURE myst ... MovieData predict ... Is this a foreign key in OLTP relational sense? ...
    (microsoft.public.sqlserver.datamining)