DSXchange

Hi folk; As for my discussion on this forum Ray advised me use srot - u to remove duplicates from sequential file. 1. For this I had checked the box stage uses filter Commands 2. then in the general tab filter command I ahs specified Sort - U - PROVIDER_ID, STREET_LINE_1, STREET_LINE_2, CITY, STATE,...

Talk2shank, Chullet
Mine is dialy load but truncate the dables and reload, there is no question of Changed data, no look up.
you can treat them as one time load

Ray,
I will work on your suggestion come back if any quesions

thanks

Folks; I have Seq ------xfm ------ora I am getting duplicate records in sequential file, I have two keys providerkey, addresskey and 8 nonkey fields STREET_LINE_1,STREET_LINE_2, ZIP_CODE, City, state,ADDRESS_TYPE, ZIP_CODE_EXTENSION_2,ZIP_CODE_EXTENSION_1 my addresskey is surrogatekey, providerkey a...

I am trying to undersatnd the basics of PX, I am wondering if some one could help on

what difference between stages decode and compress

thanks

Folks; We have enterprise stage for oracle, informix and so on, but using Dynamic Relational Stage also we can connect to these database can any one help me to understand, when do we use Dynamic Relational Stage and when do we use enterprise stage for particular type. how to differntiate them, thank...

Can I place a 1 .truncate scripts in before in SQL in ORAOCI stage 2 .SQL scripts in after in SQL in ORAOCI to perform some comparion? I had used before job sub routens and after job sub routens previously but neve used Before and after in ORAstage, just want to try some thing new and jist wondering...

Can we call routens developed in server jobs in to parelel

I have sored proceadure say ABC This reades the data from table1 and compares data in table2 and updates some data based on differences. I could develop job to do this, but if i do not want to develop a new logic in this job but just want to call this stored proceadure which will take care of rest M...

Does the project level limit over riding user level limit, if yes how to change this in the administrator

thanks

write proceadure or function; call this proceadure or function in shell scripts and call the shell script in before job execution

thanks

I take your suggestion chullet ; usaully our limit is 50 but we ahve special situation where we are going live with some business requirement need to load about 400 million records as initial load just for initial load we want unlimited. but the question here when I run the job from shell scripts it...

Hi folks; I do not have admin previlages; I am setting warning limits to unlimited in my Director but it still get aborted after 50 warnings; I am of opinion that Project level variable is over wrting and my user level; I went out to admin and told him this and he said he will lokk in to it. But if ...

I was doing the production support, and I was asked to change commit level from 50000 to 20000, I was told the programs are set up to have commit after 50000. but to my serprise rows per transaction is set 0, I was wondering where this 50000 is which I have to chane to 20000, and for moment I got do...

FOLKs, I have problem in identifying the commit command in ORA, I have million records comming in I want to commit after every 50,000 records, I was of the opinion rows per transaction under transaction handler is one which takecare of this, I had selected readcommit option but I want commit after e...

does this work? any other changes required?