DSXchange

You only missed a word and a half! And unimportant ones at that. On that basis I've removed the Premium flag. Thanks a lot ray! I think you are correct, the question came in my mind simply because i felt the build-op's might get treated as part of complete generated code than having separate object...

These days what a Transformer stage is, to all intents and purposes, is a BuildOp generator. Look at the generated code to see what I mean - though it's rather better documented than a lot of user-wr ... Can't see your reply as I am not a pemium member. Anyways thanks for the reply. Anyone has anyt...

Hi This is a bit open-ended question. In one of the jobs i am developing I used build-op instead of transformer for column level tranformation. Although I didn't have much data but in future it is more likely that i will get huge amount data for the particular job. I was just thinking, is there any ...

Hi everybody, I have one requirement where we need to delete DataSet through UNIX. My Observation is: DataSet stage creates a .ds file which is like a pointer to Data file(s) (which are binary) stored at particular location. So if I remove the .ds file and the data file will that be enough. Also I g...

If Mr Wurlod uses Job Sequences, it can't be bad :wink: quote] BTW, nothing like 'BAD' in DataStage, where IBM/Ascential might have purposefully introduced in their own produce. Its all about how effeciently we use the available option to acheive the task in an easiest way. Obviously, Pros and Cons...

Actually, there is! It's called another Sequence job. :wink: Sorry, I didn't explain what I'm thinking about. Indeed Sequence Job could call another Job Sequence made up of a job activity and two routine activities but it can't transmit in parameter the name of the job to launch. If I'm wrong, I wo...

I have worked on modules which involved around 150 - 200 jobs running one shot. At such place I can't go for sequencers. Wrong. There is actually no limit. To keep things easy to read/understand, build a hierarchy of control, using Job Activities to call other job sequences. I'm confident you can f...

My client forces me to use Job Sequencers. Reason: We can use those sequencers as part of ETL Technical Specification Document. The visual view can help to understand the flow of the DS Jobs and same can be used as part of documentation. Still the question remains if there are lot of activities and ...

You really need to show us your job design. In general it's a bad idea to have two or more writers to the same sequential file. That it works in any environment is just luck - when it goes bad it's probably a timing error. Is your test environment on a faster machine? Write the rows to separate fil...

Hi ALL, I got to take DS Export from UNIX. I found one utitlity called dsexport which I am able to use on windows. But I want to do the same on UNIX. Could anybody please let me know how can I do this, also where this utility can be found in UNIX? (as I was not able to find this utitlity on my UNIX ...

Arnd, Sry, but may be you got it wrong. I was not insisting others to do the work. Just asked thoughts on the same, as I have also not used the stage extensively so was doubtful on that. I was not aware about ray's note as I think ray put his note at the same time I put. :wink: Apologies if I did so...

I believe Transformaer will be a better option, as far as perfromance is concerned and simplicity of the code is concerned. As in transformer its very simple to just add one column. Also from maintenance perspective if you need to add some processing for said column, it will be better to use transfo...

You can use oracle plugin as a lookup directly. Another way is I think you need to create a database link(from the master database) to the other database and use oracle plugin to access the table from master database. Datbase link is needed if the lookup table in in another database. Hope that helps...