PeopleSoft EPM ASCL jobs

Xanadu · Post by **Xanadu** » Thu Aug 12, 2004 7:22 am

* This post is for guyz on Peoplesoft EPM ASCL jobs...Others, please excuse this post*

hello all..
I saw a post recently (by Athorne) where some users wanted a special section of the forum for guyz working on Peoplesoft EPM jobs..anything done in this regard.. ?
I want to join that section if at all its there ..if not y dont we start it now ?

~Xanadu

him121 · Post by **him121** » Thu Aug 12, 2004 11:50 pm

hi...
i am working in Peoplesoft EPM ASCL jobs...
i am creating all staging,Dim and Fact jobs....
so we can contribute....toeachother and to this site...
i will appreciate ur interest.....

Xanadu wrote:* This post is for guyz on Peoplesoft EPM ASCL jobs...Others, please excuse this post*

hello all..
I saw a post recently (by Athorne) where some users wanted a special section of the forum for guyz working on Peoplesoft EPM jobs..anything done in this regard.. ?
I want to join that section if at all its there ..if not y dont we start it now ?

~Xanadu

BradDriver · Post by **BradDriver** » Fri Aug 13, 2004 1:49 am

I would also like to join a Peoplesoft group if one ever gets set up

Xanadu · Post by **Xanadu** » Fri Aug 13, 2004 7:44 am

Thanks for your posts Him and Brad...
Hopefully the site administrators are hearing this...

Do you have any idea why they use char instead of varchar in staging/production..i dont see any spl adv of using it...i thought DBAs for all practical purposes stopped using char unless its migration from some legacy system...
any ideas ?

BradDriver wrote:I would also like to join a Peoplesoft group if one ever gets set up

BradDriver · Post by **BradDriver** » Fri Aug 13, 2004 8:37 am

Chars save some space but they should only be used for fixed length fields. Varchars are better for fields like names etc.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 13, 2004 9:14 am

Keep in mind, though, that most bulk loaders prefer fixed length format files, as does Quality Stage.

Xanadu · Post by **Xanadu** » Fri Aug 13, 2004 9:34 am

ray.wurlod wrote:Keep in mind, though, that most bulk loaders prefer fixed length format files, as does Quality Stage.

oops i actually asked u the same question in another thread(adv of char over varchar..)..thanks for answering..
regarding bulk loaders preferring fixed length...I am referring to EPM implementation...so everything is done using DRS stage...no bulk loaders at all..

ray.wurlod · Post by **ray.wurlod** » Fri Aug 13, 2004 9:24 pm

It's not impossible that, at some future time, PeopleSoft may adopt Quality Stage as the preferred tool for name and address cleansing and, maybe, certification.
And the RTI components may end up being useful as Web services supporting the PeopleSoft application!

sumitgulati · Post by **sumitgulati** » Mon Aug 16, 2004 4:48 pm

I would also like to joing a PeopleSoft group if it gets created.

DSXchange

PeopleSoft EPM ASCL jobs

PeopleSoft EPM ASCL jobs

Re: PeopleSoft EPM ASCL jobs