Confusion for loading data

Hi,
I am building in a data mart using SQL server DTS. I have
confusion that
Example
Suppose we have text file for Cust table. It has 3
customers
A,
B,
C
This information comes in text file from legacy system.
We load this data in cust table in staging.
Now we get a new text file with 5 customers i.e
A,
B,
C,
D,
E.
What query shall I write to include the 2 new customers
i.e D & E in my Staging Table. How will I refer to text
file. Meaning that
select new_customers
from text file (what shall I write here to refer my text
file).
Or how is done.
If some one can solve this simple puzzle it will be great
help.
Thanks
Steve
What I usually do is import the text file "as is" in a staging table and
manipulate the data from there. Tables are a lot easier to query than text
files.
You can get your new customers with a query similar to:
SELECT customer AS new_customer
FROM staging_table s
LEFT OUTER JOIN existing_table e
ON s.customer = e.customer
WHERE e.customer IS NULL
Jacco Schalkwijk
SQL Server MVP
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:49d101c47392$055e44a0$a301280a@.phx.gbl...
> Hi,
> I am building in a data mart using SQL server DTS. I have
> confusion that
> Example
> Suppose we have text file for Cust table. It has 3
> customers
> A,
> B,
> C
> This information comes in text file from legacy system.
> We load this data in cust table in staging.
> Now we get a new text file with 5 customers i.e
> A,
> B,
> C,
> D,
> E.
> What query shall I write to include the 2 new customers
> i.e D & E in my Staging Table. How will I refer to text
> file. Meaning that
> select new_customers
> from text file (what shall I write here to refer my text
> file).
> Or how is done.
> If some one can solve this simple puzzle it will be great
> help.
> Thanks
> Steve

Confusion for loading data

Hi,
I am building in a data mart using SQL server DTS. I have
confusion that
Example
Suppose we have text file for Cust table. It has 3
customers
A,
B,
C
This information comes in text file from legacy system.
We load this data in cust table in staging.
Now we get a new text file with 5 customers i.e
A,
B,
C,
D,
E.
What query shall I write to include the 2 new customers
i.e D & E in my Staging Table. How will I refer to text
file. Meaning that
select new_customers
from text file (what shall I write here to refer my text
file).
Or how is done.
If some one can solve this simple puzzle it will be great
help.
Thanks
SteveWhat I usually do is import the text file "as is" in a staging table and
manipulate the data from there. Tables are a lot easier to query than text
files.
You can get your new customers with a query similar to:
SELECT customer AS new_customer
FROM staging_table s
LEFT OUTER JOIN existing_table e
ON s.customer = e.customer
WHERE e.customer IS NULL
Jacco Schalkwijk
SQL Server MVP
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:49d101c47392$055e44a0$a301280a@.phx.gbl...
> Hi,
> I am building in a data mart using SQL server DTS. I have
> confusion that
> Example
> Suppose we have text file for Cust table. It has 3
> customers
> A,
> B,
> C
> This information comes in text file from legacy system.
> We load this data in cust table in staging.
> Now we get a new text file with 5 customers i.e
> A,
> B,
> C,
> D,
> E.
> What query shall I write to include the 2 new customers
> i.e D & E in my Staging Table. How will I refer to text
> file. Meaning that
> select new_customers
> from text file (what shall I write here to refer my text
> file).
> Or how is done.
> If some one can solve this simple puzzle it will be great
> help.
> Thanks
> Steve

confused!....cube or data mart?

hi
u can go for a datamart there is no ned for u to go to a
warehouse as ur scope is less and regarding to the cube i
didnt understand ur question.

>--Original Message--
>hi ppl...
>i'm a final year student in information systems and a
new comer in the field of data mining. i'm developing the
application using VB 6.0 for the front end and i'm using
SQL server 2000 : Analysis services for the back end.
taking customer transactions, my aim is to predict
customer buying patterns. im confused as to whether i
have to implement a data mart or a data warehouse to hold
my data.i'm also confused about the cube funtionality,
whether it has anything to do with data warehousing/mart.
the project scope doesn't include gathering data.
>.
>thank alot...but i'm confused as to what a data mart is? there are facts and
dimensions in data marts as well as in cubes. what is the diference between
these two. hold do i implement a data mart with regard to my project? does
analysis services provide t
he funtionality of building one?if so how is it done in context of my projec
t
thanks|||Maybe this help - http://199.239.255.16/html/articles.html
Ray Higdon MCSE, MCDBA, CCNA
--
"jrock" <anonymous@.discussions.microsoft.com> wrote in message
news:C2D503FC-DE46-4724-A6EA-EC657D29249C@.microsoft.com...
> thank alot...but i'm confused as to what a data mart is? there are facts
and dimensions in data marts as well as in cubes. what is the diference
between these two. hold do i implement a data mart with regard to my
project? does analysis services provide the funtionality of building one?if
so how is it done in context of my project
> thanks
>