DSXchange

thanks lstsaur! BTW i noticed an interesting coincidence. we have joined alomost on the same day :D

Hi, One interviewer asked me the difference between transformer Stage and the rest stages. I couldnt answer this if anybody know about this. rest stage is used to "relax" :D while transformer stage does all the hard work. Jokes aside, Transformer stage slows down things and it is a residu...

great Ray! thas works great :D

Hi All, my source is a flat file and target is oracle(oci). I need to update the table based on the key columns, but in my situation if the source has spaces in the not null columns I am using trim function for all the columns Suggestions required please Thanks in advance Saik Hi Saik, trim of all ...

any suggestions??

Sorry , posted in a wrong forum , This is for Server jobs

Hi DS Folks, i am trying to get all the individual jobs export dump for version control purposes. i am using dscmdexport , a client utility, to export the indiviudal job dump. As i don't know the list of projects and job names to export , i have to execute dsjob with params -lprojects and -ljobs to ...

If you persist in using a database sequence, doesn't that introduce a choke point in your loading paradigm, as direct partition loading would require a semaphore to manage doling out numbers to the parallel threads ? Wouldn't you prefer to stay with an optimized loading method of allow all partitio...

Ray, are you listening :) Not while I'm working. While I'm working I give my client's tasks my full attention. I only visit DSXchange during breaks, or before or after work. Hey Ray, take it easy. i have not meant this forum like a chatting window. :oops: i was hoping to get your views, thats all

kool_cons wrote:problem is solved if i input the field like mm-dd-yyyy instead of yyyy-mm-dd.
thansk guys.

maybe a redundant answer but....

alwasy rt y to say view data from any input stage and see what the sample data looks like and convert it accordinly

2 points more that I'd like to add: 1. If you have a warehouse to be built for a (very) rapidly growing client(Retail would be a good example). And lets assume that his data volumes are expected to increase say by double every quarter(it is possible). However considering the client's area of operat...

Ray, are you listening

I agree that there's a need for something like the SDK suite for parallel jobs; such a suite is indicative of a mature product - it took some years before it was developed for server jobs. Exactly, the whole idea of using an ETL tool is to bring down the development time. From my experience, the pr...

hi, To handle this, go to the sequential file, format tab, field defaults. select the property NULL field value and give any random value such as "@" and run the job and then try viewing the data. now where ever nulls are present the symbol would replace and you would be able to view the ...

Prabu, If I want to force inserts and not use the bulk load process, I will choose the options 'update then insert' or 'insert then update' and afterwards choose 'custom sql' for both; then I'll cut-and-paste one to the other, so that both actually do the update or insert. But if you only have inse...