[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-warehouse-l
Subject:    RE: Info on Data Junction
From:       "Parandhaman, Shyam" <Shyam.Parandhaman () cendant ! com>
Date:       2002-11-12 14:58:49
[Download RAW message or body]

Hi,

DJ is an inexpensive, nifty tool for the kind of requirement you are
mentioning.
We used it in one of our Data warehouse projects(for ETL purposes).

It worked well. I do not know about the scalability because our environment
was
of medium size(few million records per day).

It has lot of standard simple transformation functions..
Finally, The tool was not that expensive for a five user license!!

Regards,



-----Original Message-----
[mailto:NSuchitr@chn.cognizant.com]
Sent: Tuesday, November 12, 2002 7:59 AM
To: Multiple recipients of list ODTUG-WAREHOUSE-L




> Customers  send files in different formats and layouts . These files are
> now manually converted to standard format using MS-ACCESS. Then these
> standard files under go a series of process. 
>  
	We are  trying to automate this process, or I should say reduce the
effort involved in the process of standardising and moving the files around.

>  
> Towards this we are considering the use of DataJunction for Standardising.
> What I would like to have is a User Interface where a user can map the
> layout of the incoming files to the layout of the standard file .Secondly
> I would like to have a provision for them to save the mapping. This will
> help them pick this mapping (and the uderlying script generated by
> DataJunction) and assign it to a new file so that they don't have to map
> the file each time. 
>  
	Can anyone suggest how we could do this...
-- 
Thanks to everyone for making ODTUG 2002 a great success!  Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
-- 
Author: Parandhaman, Shyam
  INET: Shyam.Parandhaman@cendant.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-WAREHOUSE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]