DSXchange

if you are working with a join stage you migth want to check following posts: http://www.dsxchange.com/viewtopic.php?t=89064 http://www.dsxchange.com/viewtopic.php?t=88888 which are both about fields with the same name in different inputs. If you're working with the difference-stage these don't offe...

thanx for the hint, but when I try this it seems harder to get information for deleted records. In the compare stage I can easily log some info from the before record for the ones that are not in the after image (which can make it easier to do the correct updates for this delete). this looks more di...

next time I'll think longer before posting, but Actually it seems one difference-stage can provide me with all 3 outputs

I'm setting up a new DWH and now we're working on the templates for filling dimensions. What we now have is that everything is coming in daily(no delta's but complete tables), and we transform this into the same format as the dimension table. At this point we need to do 3 actions -check for inserts:...

in DS you can use the variables inrownum and outrownum. I think inrownum is the one you need. This counts for every row in the input and always starts from 1 if the job starts.(migth be a bit tricky if you're rejecting rows from the output).