DSXchange

Ken ... ah yes ... consulting in 'Paradise' is as good as it gets (but the downside is that none of my clients are here). Thanks for the tip - looks like you and Mike are on the same page. Mike ... GDG is great idea. That would work for me! But I need a little help here: once I get it, how do I driv...

Hi Folks ... Can anyone suggest an elegant way to get a MAX surrogate value into a DS390 transform (to be used as an assignment start point)? Were this a server job I would use the built-in key management function. I'm presently doing a MAX to obtain the highest value and then using a JOIN to connec...

I intend to propose a MetaStage solution for a HUGE bank metadata problem. Wanted to offer a follow-on thought ... when you mention HUGE you need to be aware that Ascential recommends that the MetaStage repository be limited to approximately 500 DataStage jobs. This is a performance recommendation,...

AreiAR ... 1) When you figure out how to automate the CONNECTED TO between DEV and PROD, please let me know. 2) Regarding the importation of thousands of copybooks into DataStage, have you considered using ERwin to reverse engineer models from the copybooks? If so, you could then export from ERwin, ...

The answer to your first question regarding CONNECTED TO is yes, this association, once created, will survive subsequent imports. You must record your actions here since this connectivity must be recreated when you move from Development to Production, i.e., it cannot be exported (I know, I know ... ...

... very comprehensive ... thanks Ken.

... tom

kcbland wrote: ... Your migration path is affected by this design choice.

Thanks for the feedback guys ...

Ken, would appreciate a little more detail on how this approach will affect migration.

... tom

If you must write to the same file from two transformers, the file cannot be a flat file. I have been successful with multiple sources writing to a hash file.

... tom

[Sometimes it's not our choice ... Guess what! Now I, as a M204 DBA, with no experience and no training in DS get to inherit it. ] Glenn ... I have a good bit of empathy for your situation, but you are now in an excellent position to demand training to ensure the integrity of the corporate data. I t...

Pey ... (The following assumes you have done an import from DataStage). Open the Explorer and go to Edit => Find. Under Look In choose Ascential DataStage6 and Column Definition (Hidden). Click the Advanced tab and under Attribute choose SQL type, for Consition choose = and for Value enter char and ...

James ... There are a couple of issues here. There should be no problem with importing DataStage from different projects on different boxes into the MetaStage repository. When you initiate an import, you just log onto the server and identify the DataStage project of interest. However you will need s...

Ken ...

Really appreciate the time you put into this ... this is wonderful stuff and your insights are valued ...

... tom

It will take care of itself ... when you edit the RunImporter.cfg file, add your password in plain text, i.e., you don't need "encrypted". When the process runs, it will encrypt the password. Take a look at it after the first run.

... tom

ERwin Import: Has anyone come up with a technique for programmatically identifying those ERwin tables which have changed since the last import? This seems to be one of the first questions asked by my clients. I must presently rely on verbal instructions from the Data Architect as to which have chang...

Actually the solution here belongs to ButlerHD: mulitple links to the same sequential file will not work for the reasons already expressed -- but it will work if you write these links to a (keyed) hash file.