DSXchange

Stupid beginner questions since this is my first time with the DT stage.

1. Can a Distributed Transaction Stage be used without a MQ Connector?
2. What purpose would the DT stage serve in my case as against a standard Oracle connector?

Thank for the guidance, Ray. I'll try this approach and post tangible updates, if any.

We have internally decided to use parallel jobs. The only reason why the 'parallel or server' question came up was because all of the existing ETL has been built using server jobs and the support guys were very skeptical due to their lack of experience in handling parallel jobs. We've now convinced ...

Hi,

I'm looking for advice on whether a Server Job or a Parallel job is more capable to efficiently load an Oracle nested table.

Any pointers to possible design approaches would be very helpful. Thank you

Which version of Db2 do you have? It's been more than a year since I last worked with Db2 but I do remember using either 'CHAR()' or 'TO_CHAR()' in a way very similar to Oracle. (Edit) Found this - http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.1.0/com.ibm.db2.udb.admin.doc/doc/r0007108.htm

Thank you Franklin. The first line of your post is a part of my solution for sure. Helps me channelize the next few hours in a better direction. :D

Hi, We have a Multi format source file that has a header followed by details and finally a summary record. Now this file isn't restricted to just one header but multiple header/detail/summary groups. A typical file would look like H10 A B C 20140827 D10 1 2 3 4 5 6 Ab CDE FG D20 A B D20 X Y D20 M N ...

Data Experts! This is not a DataStage question. It's in fact a query that needs tuning. It sits in one of the views that DataStage reads from and it's driving me crazy! I have a query that looks something like this SELECT * FROM X INNER JOIN (SELECT * FROM B WHERE ....) Y ON X.key=Y.key INNER JOIN (...

Got it. It can be done using a Stored Procedure stage. But if the anonymous block has a declare section, then the block should be wrapped within another block of For posterity :D

Hi, What is the best way to execute an anonymous PL/SQL block in a server job? Though the logic within this block can be implemented in a job, we are trying to minimize the number of stages to touch to reduce the re-wiring required since this is an existing job. I tried to do it in the after sql in ...

chulett wrote:...
Worst case, export the project and do a string search in it for the hashed file's name.

Why should this be the last resort? Any specific reasons?

Hi,

One of our client's existing DataStage jobs involves a process that reads from a hash file for a lookup. the hash file's metadata seems to have been manually entered.

I need to find the job that's creating this hash file to make some modifications. Is there a way to do this?

Thank you Ray. Can you please elaborate on what exactly should I be looking for under that folder?

Hi, I'm facing a peculiar issue with my DataStage client and the team is unable to figure out the issue. Below is a list of issues 1. Cannot create new folders in the repository. 2. Cannot import table definitions 3. Cannot compile sequencers. Always get INTERNAL COMPILER ERROR 4. ctrl-F5 shortcut t...

That's what I thought and hence was expecting the exact same value at the source to be written to the file. I'll try to widen the field and verify