DSXchange

First thought is that either of your 2 stage variables are causing the discrepancies, how are they being calculated? That's what I was thinking too, but just not seeing the how/why. svpaidinmm is defined as: if DSLink47.paid_in_increment_id = DSLink47.ID Then 1 Else 0 -- Basically if this is the fi...

All, I have 2 jobs designed that when executed for a smaller data set work fine, but when opened up to the full population I get different results for the same records. Here is the high level data flow: Job 1 -->> Execute simple query and separate data into 2 different ouputs (sql server bulk loads)...

Got it. Just waiting on my renewal for the premium membership..tick tock..

If I were you, I would seriously consider this technique posted by Ken Bland back in the day for using hashed files to do range lookups. I've implemented it in the past and it is sweet once it all cli ... You wouldn't happen to know the thread title? I've searched on a range lookup, but found nothi...

So, I did get the business to agree to 15 minute increments rather than by the minute. What I'm basically looking at now is the following: Employee # Clock In Clock Out 1 8:15 AM 3:30PM .... Time Increment ID's Start Hour/Minute End Hour/minute 1 08:00 08:14 2 08:15 08:29 3 08:30 08:44 4 08:45 08:59...

One of my source systems it appears has decided to put your random CF/LF's into a couple fields. What are some methods you employ to inspect and remove them where they don't belong?

Thanks for any suggestions.

So you need a head count of all employees that have clocked in but not clocked out yet (in the past 15 mintues) or regardless? Either way, you have the clock in and out times, let yout job calculate the time that was 15 mintues ago by going back 900 seconds from the current timestamp and then extra...

I haven't done anything like this, but you're looking to target multiple 15 minute time blocks per clock record, yes? :? ... Yes, my initial plan is to do down to the minute (I know, it's a long story), but my time dimension at the end of this processing will allow it to be rolled up by 15 minute i...

DSguru2B wrote:So you need a head count of all employees that have clocked in but not clocked out yet (in the past 15 mintues) or regardless?
Either way, you have the clock in and out times, let yout job calculate ...

I don't have premium content (I'm a slacker, my company won't pay) but I think I get your drift.

I was looking to get some feedback or suggestions as to how to structure the logic or design for ETL. I have a time clock data coming from a time keeping system. Basically it has 'clock-in' and 'clock-out' date and time. The requirement I have is to provide a Headcount(how many employees on the cloc...

Kim,
Does etlstats work on ver 8?

Ray,
My premium membership is expired, so please bear wtih me.

my apologies. Updated now.

some more input, this is the single job code I have now, but it's not performing as expected.. It needs to break out after each center and move to the next. I've probably been staring at this code too long and its something smal that I'm missing. Thanks for any input: DefFun DSU.HashLookup (A, B, C)...

All, I have a job that needs to go to muptiple servers and run the exact same job(s) at each server. I'm struggling on whether to just code a one looping job solution OR use sequencers to call the same job(s) multiple times. There are about 85 locations that need to be executed at. Right now, I have...