DSXchange

Never used it before, can't seem to find it in the Oracle Stage on my version. Under the SQL tab I only get "Generated", "User-defined", "Before", "After", and 2 DDL tabs (or I may need a new pair of glasses :o). Anyway I guess it would make moving jobs to pro...

Hi, i'd like to use an oraoci8 plug_in with the option "User Defined SQL Query File" because i have a very complicated query. i set the options... but: where can i specify the name and the directory of file with the query? tanks in advance Mario Loreti :D, No such thing. You enter the que...

nsm wrote:Code to populate Hash File:
SELECT web_key,upper(rtrim(web_text)) FROM WEB_DIM

From the source:
upcase(trim(DSLink3.web_src_text))

This is the code i am using to compare the incoming and hash value.
suggest me,if you get any ideas.

nsm.

Both rtrim or both trim?

Ogmios

Hi, Could anyone throw light briefly on how to migrate data stage jobs into production environment. Thank you in advance. iowaJAK 1) Version Control that comes with the tool 2) Export jobs (in DataStage manager) from the development environment, import them in production and compile them with Compi...

Use Microsoft Excell to generate the data, output it to .csv format and load it with a DataStage job.

For small amounts of static data manually enter it via your favourite SQL tool. For the amount of data you need, do it manually.

:D

Ogmios

Post the code that does the comparison please.

Ogmios

ROFL :D, you've got to admit that in some areas DataStage itself is not of the best quality. I once overheard someone describe DataStage as an "overgrown PacBase for SQL with featuritis of which not all features work as they should". But now we're getting very off-topic :wink: . E.g. About...

And this is called "programming around the DataStage limitations" instead of "programming with DataStage". And the more you work with the DataStage the more you realize there's an awful lot of things to work around. After a few years you sometimes just wonder why you even bother ...

For the performance issues, this is where the black magic starts. What I "usually" do: load a file with small width (little columns) and do a straight load in DB2 (without transformations or constraints). This will give you a good idea of the maximum throughput possible. If it does not dif...

Disadvantages of the DB2 bulk loader stage: * makes a control file that clearly shows the passwords * Has problems with non local DB2 systems (tries to write to directory structures that it fetches from the local system, when the local and remote system do not have the same layout....) * Does not ex...

If jobs sometimes don't startup, it may be time to make the T30FILES parameter larger (search for it on this site). We've had it in the past where this maximum number of concurrent open hash files was reached and this results in some jobs not starting (since each job needs 4 hashfiles just to start)...

Been there, done that. Just wondering why they ever bothered making the operator role like this. I've yet to see one place where they use the operator role. It shouldn't be too hard for Ascential changing it to: "an operator can stop/start jobs, see log files but make no structural changes in a...

I tried it in Windows environment. It aborted as it can't create a file with with ':' in it and the 'DSJobStartTimeStamp' comes back with a value which has ':' in it .. Change the ':' to '_' with ereplace afterwards. Put the calculation of the date/time in a controlling job passing the value as a p...

100 rows per second seem to be about right when you use a couple of lookups. As a test (on a test database) remove the lookups and check the speed, depending on your system you should be able to get between 1000 and 2000 rows per second. The trick we usually do is to load the table to a (staging) ta...

Guido. Look at the following threads: http://www.dsxchange.com/viewtopic.php?t=85810 http://www.dsxchange.com/viewtopic.php?t=83754 Apparantly some people have managed to get it working (I never did :twisted: ), but what would be the point in doing this via DataStage. I needed it once: then I stored...