DSXchange

Hi Anu, You can create a "Sequence job" which has three 'wait-for-file activity stages, followed by a 'job sequencer' stage, followed by three 'job activity' stage for running the jobs which load the staging tables and then a final 'job activity' stage for running the job to load your tar...

There's no functionality inherent in the products for monitoring file availability. There are various methods, some using Unix scripts, others using DS BASIC or Sequencers, for detecting the presence of files. No matter what, you will program your own solution. As far as what I would do, I would wr...

Hi all, I have 3 different source files which are supposed to be FTPed to my server every month, then I load them into 3 seperate staging tables. From 3 staging tables,after doing some math, i need to load final table every month. My requirement is, I need to look whether I have received all the 3 f...

Jahnavi wrote:Thanks! Found it.

Could you please post your findings here ?

Hashed File stage can only do key-based "=" lookups. If you really do need to lookup against non-key columns in a hashed (not "hash") file, you can use a UV stage. It will be slow unless you index the search columns. Search the forum for more information. Thank you all for the v...

Apply your business rule while creating the hash reference file for the previous month to be compared with the current month records. You need define key column/s in your hash file. In your case I am guessing it will be ticket number. Your hash file will have the ticket number key plus domain, regi...

Anu Could you provide example for us to understand what you want. This will help in understand the requirement Siva Thanks for the reply Siva. I have an open TICKET from a particular Domain/Region (A/B) in current month.Iam trying to find out whether there is any TICKET(s) with same Domain/Region (...

Helo gurus, I want to compare non-key columns of an Hashed file with incoming data and apply some business rules. I have cols. A,B(both are not keys in hash/source) of current month.I want to compare A/B with A1/B1 of an Hashed File (being created from same source table, but contains entire data inc...