DSXchange

quote: Originally posted by bigpoppa [br]Well, just to corroborate. There is no 'first' functionality in the PX aggregator. To get 'firsts', I've always written a very simple buildop that takes in sorted, grouped input and spits out the first record in each group. I don't understand why it is necess...

quote:Originally posted by kduke
[br]I think the dsjob command can also reset.


Yup, sure do.

dsjob -run -mode RESET [project] [job]

-T.J.


* * *

... now if this can make breakfast, my life is complete.

quote:Originally posted by kduke
[br]Life could be a whole easier if you had a little help with a good tool. Might get a little more sleep too. Huh TJ?


Oh, I agree. Umm. Hmm. I seems to be missing something here...

-T.J.


* * *

... now if this can make breakfast, my life is complete.

With 1 key, get first for a field, and last for a field? * * * [input stage 1] ---> [Filter Stage] | v [Merge] -----> [whatever] ^ | [input Stage 2] ---> [Filter Stage] * * * For the first input stage, get key, and first column. For the second input stage, get key and second column. Filter Stage are...

Hello all, 1. What is the best set up for our Dev and Prod environments? Do we keep DataStage Dev with MetaStage Dev, and Prod DataStage with Prod MetaStage? 2. What is 'Best Practice' for moving from Dev to Prod (For both DataStage and MetaStage)? 3. How do we ensure that we keep our Dev and Produ...

quote: Originally posted by chulett [br]We must fall heavily into the "don't mind" category as it works well for us in our environment. [:D] YMMV, of course. I am not saying that it does not work. It work. Very well, in fact. It just did not fit our business needs for those reasons I detai...

Can someone please suggest a way to generate unique sequence numbers within Ascential. The purpose is to assign that number to a column in a table each time a new record is created using datastage. Currently I am using Oracle sequences (and having a trigger on insert on the table to populate the co...

Thank you for taking your time to help finetune what I am trying to express. For the three main types you mentioned, I sense that the last two are critical for us -- Technical and Process. Based on what I read on this topic, we practically have to change our culture, plan everything, and reinvent th...

From a basic perspective, how will developers and end users know what is in your Data Warehouse? Using ERStudio Viewer, and SQL Navigator. We also use Table Definitions Import, which we DO find to be a great boon, but we are also aware of its limitation -- the inability to detect changes. However, ...

quote: Originally posted by gpbarsky [br] I need to know if there is an application to handle the different versions of a job. If you do not require anything more than just a simple migration tool, and you do not mind an unwieldy attempt to migrate individual jobs or group of jobs (which does not ea...

You know, I have a problem here. As I read the threads on this forum, full of people saying, "DO IT! RIGHT AWAY! PLAN RIGHT!", I am left with one thought: Why? Why is it so important to use MetaStage? What is the value that it really provide to us? How would it improve our ability to utili...

Everyone -- Thanks to the mailing list (Oliver.com), I got the clue that I seized upon to provide this solution: If IsNull([FIELD]) Then Space([LENGTH]) Else If ([FIELD] = 0) Then Space([LENGTH - 4]) : "0.00" Else Right(Space([LENGTH]) : (Field(Trim(Trim([FIELD]), "0", "L&qu...

quote: Originally posted by vmcburney [br]3) There is a compile all tool on this site which will let you recompile jobs in bulk, this leaves them at the same state as a reset. I believe Twister will be offering mass-compilation as an option. -T.J. * * * ... now if this can make breakfast, my life is...

You need to go visit the MetaStage forum moderated by Barbara Nichols on this site. She is the foremost expert on methodologies and implementations of MetaStage. Read her bio to get more info. Hehe. I am very aware of her. In fact, I have been constantly trying to convince my company to hire her to...

Your description misses the most powerful aspect of ETL as performed by DataStage, and that is inherent metadata management. IF you have established your business rules, designed your target database and contemplated "luggage labels" (data elements) for your data, all these can be importe...