Re: A few question if you have time.

[Arun Kumar <arunkumar13@YAHOO.COM>]

Alan,
What kind of validation you are looking for?
If you are just changing your database platform then
why do you have to validate?
I mean if you carefully look a sample of data would be
enough to make sure that program is doing fine.


Arun
--- "Lantinga, Amy" <Amy.Lantinga@MARRIOTT.COM> wrote:
> I didn't think Data Mover Scripts Validate.  How
> about Import Manager?  That
> validates all the On Line Edits.
>
> Amy Lantinga
> Project Mercury
> (678) 657-5614
>
>
> -----Original Message-----
> From: Banks, Richard
> [mailto:Richard.Banks@CBA.COM.AU]
> Sent: Tuesday, February 05, 2002 5:25 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: A few question if you have time.
>
>
> Since you are talking PeopleSoft what about using
> Data Mover Scripts (DMS)
> not just to import/export your data but to also
> validate it?
>
> Once you have the data in both databases you could
> run the same export DMS
> against both and compare the filesize/checksums on
> the 2 data files.
>
> This assumes that DMS saves the data in the same
> file format regardless of
> the source DB, which seems a reasonable assumption.
>
> Drawback would be if there is anything different
> between the two versions
> the DAT file is not a text format for easy
> comparison.
>
> But hey we're talking PeopleSoft, Oracle and IBM
> here, what could go wrong?!
>
> > -----Original Message-----
> > From: Alan Ljungberg
> [SMTP:Alan.Ljungberg@CNPL.ENBRIDGE.COM]
> > Sent: Wednesday, 6 February 2002 7:50
> > To:   SQR-USERS@list.iex.net
> > Subject:      Re: A few question if you have time.
> >
> > Hello Sam,
> > Much appreciate the time spent in helping me here.
> > The issue isn't with the loading of date fields
> into Oracle.  The problem
> > is in validating Oracle date outputs against DB2
> date output, without
> > using
> > custom date variables.  What I would like to do
> after the Oracle db is
> > loaded is use the same SQR to output the Oracle
> tables to flat files then
> > compare the DB2 flat files to the Oracle ones.
> >
> > And yes there is a lot to sort through.  We are
> talking some 1374 total
> > columns 140 of which are date columns in various
> positions, all different.
> >
> > Since Oracle seems to be friendlier to this kid of
> manipulation with the
> > ALTER SESSION command I think we will leave the
> DB2 scripts as is and add
> > the add this SQL command to the Oracle versions to
> make the output formats
> > match.  That is unless someone has a better
> suggestion.
> >
> > -Alan.
> >
>
>
> **************   IMPORTANT MESSAGE  **************
> This e-mail message is intended only for the
> addressee(s) and contains
> information which may be confidential. If you are
> not the intended recipient
> please advise the sender by return email, do not use
> or disclose the
> contents, and delete the message and any attachments
> from your system.
> Unless specifically indicated, this email does not
> constitute formal advice
> or commitment by the sender or the Commonwealth Bank
> of Australia (ABN 48
> 123 123 124) or its subsidiaries.
> **************************************************


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com