DSXchange

Thanks Ray. What I'm really looking for is a better understanding of how DS 7.x launches external commands under Unix.

If these details are doc'd somewhere, sorry, please point the direction. I searched on "Execute Command" before posting but got too many false hits.

Hi, I need to execute an external command in a sequence, where that external command needs a number of environment variables set. From what I can deduce, the Execute Command stage executes the external command in the Bourne shell (sh). Since my environment files use the bash syntax, I need to also s...

Thanks for the replies. I ran into two issues with this approach: 1) For the sequential files, I wanted to first aggregate the data, as I needed frequency counts per primary keys. If I didn't first aggregate, I couldn't see how to get the frequency counts in the final aggregate stage from multiple i...

Hi, I have data from disparate sources (sequential files and database tables) and need to get frequency counts based on the keys. Very simplified example: seq_file --> aggregator --> output_link_1 db_table --> select count(*) from db_table group by key1, key2 --> output_link_2 etc. ... 5 more data s...

I've had the DBA create appropriate indexes and the performance is now acceptable.

Thanks for the help...

Hi, I'm implementing SCD2 processing against a target SQL Server table. Excerpt from the job: xfm --> Update --> Target Table xfm --> Close --> Target Table xfm --> Insert --> Target Table where Update/Close/Insert links are from the same xfm and to the same Target Table. In other words, one xfm sta...

(I have watched the video and read the install instructions, plus searched on "ETLStats" before posting...) Quick questions about ETLStats: 1) Can I install the jobs into their own project, then report on all the other projects? Or do I have to install the ETLStats jobs in each project on ...

chulett wrote:Of course you can! Switch the stage to user-defined / custom sql and change the "=" to ">=" just like you've noted and you'll be fine.

Doh! Should have read the help before posting (sorry).

Yep, that fixed it. Thanks for the help!

Got no clue how SQL Server does locking, so totally guessing here but... array size? Have you tried setting all links to 1? :? Darn, you're just too fast for me Craig :wink: Yep, I was just about to post that I've solved my own issue. I changed Array Size from 1 to 1000 and Transaction Size from 0 ...

Hi, This post is related to http://www.dsxchange.com/viewtopic.php?p=332965 So now my job looks like (excerpt): NotBackDated ---------> BackDatedBalance -----> TargetTable (all three links, same DRS stage) BackDatedOpted -------> NotBackDated is "Update or Insert" BackDatedBalance is "...

Use an immediately updated hashed file in the process, to detect whether the record has already been processed (and which will always contain the most recently used value), then Insert or Update into the target. If you prefer, interpose an Aggregator stage to group by key and only deliver the Last ...

Hi, I have to implement processing where, if a "backdated" record occurs, update a column for all records greater than or equal to the backdate. Say I have this data in my target table: KEY DATE FLAG_VAR 1 20090701 T 1 20090702 T 1 20090703 T 1 20090704 T 2 20090701 F 2 20090702 F 2 200907...

I have a source oracle table,transformer and sequentail file. when i run this job i want to see number of records count + all records in sequentail file. row count: 2 column1 column2 1 XXXX 2 XXX Show us 1) exactly what you have (your source), and 2) exactly your desired output (your reformatted so...

Look for /etc/vimrc, /etc/vim/vimrc, or /usr/local/share/vim/vimrc.

Or do , then go get a cup of coffee

Or create ~/.vimrc, which should override any global settings.
should tell you which initialization files are used.

HTH

1) It remembers where I was in every dang file from session to session and puts me back there when I vi it again. I would prefer to just start at the top, is there a setting for this? http://durgaprasad.wordpress.com/2007/02/21/remember-file-cursor-position-in-vim-solaris/ http://ubuntuforums.org/s...