DSXchange

Please advise exact version (8.0, 8.1, 8.5 or 8.7).

Are you having a particular problem? If so, what is it? What error messages are you getting?

Two requests. 1. "Step to next link" (and maybe "step to next row") functionality, as in the server debugger. 2. The ability to toggle breakpoints on links that transition a boundary into a local container. (Shared container would be nice, too, but I can envisage rather more diff...

In short, make absolutely sure that your date picture matches the format of your data. And make sure, if you're using it, that the second and third arguments of the substr function are correct.

Sort by project_id, year, account_period and category in a Sort stage, generating a key change column.

In Transformer stage derive stage variable svRunningTotal value as follows.

An alternate logic would be to use a ranking function in the presentation layer (e.g. a query) rather than using an ETL tool to perform a non-ETL task.

So what if it's 2013-02-28? Do you want it to take you to the last day of the previous month (2013-01-31) or the corresponding day number (2013-01-28)? Now do you see the dilemma?

Any time you're working with a sequential file - and this includes the Merge stage - you must mention the entire structure. The term "sequential" implies that you have to read past every byte in the file to get to the next one.

How would YOU specify the function's behaviour? What do you believe the function should return from the original example?

There is no 31st of February.

Few places in the world have a financial year ending on April Fools' Day. There's much more you can do with these functions. For example: MonthFirst (first day of current month) - three different ways: DateOffsetByDays(TheDate, -1 * MonthDayFromDate(TheDate)) DateOffsetByComponents(TheDate, 0, 0, -1...

I have a theory about what this function is doing. Having pondered this theory, I am forced to wonder how they could have done it any other way. The problem is that not every month has 31 days. It seems (from other tests such as DateOffsetByComponents("2013-03-31", 0, 1, 0), which returns ...

Using job parameters rather than constants made no difference.

The following works. but this one gives the same results you found. Maybe -1 is a special number - like, you know, i-squared.

Last time I did one of these (different souce and target from yours) I used a sequence to run a server job that created the SELECT statement by reading the system tables, and passed the SELECT statement to the main job as a job parameter. Worked beautifully.

Missing right parenthesis?

I think you may have bumped into a bug. Certainly what you're doing accords with the Information Center documentation for this function.

When is the interview?

As noted, state the (full) requirement in words. This is called a specification, and may serve a useful mind-focussing exercise - you may even be able to come up with your own best solution.