DSXchange

You might want to start with a book .. some good real world usage scenarios are to be found in there.

http://www.worldcat.org/search?q=isbn:0764567578

http://www.redbooks.ibm.com/abstracts/sg247576.html

HTH

Any specific things that you'd like suggestions for? IBM has posted a pretty neat checklist which should help you through installation as well as give you a good place to start should you need to contact IBM support. http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r1/index.jsp?topic=/com.ibm.swg...

Is the problem only with jobs loading to Oracle? Do DataStage and Oracle reside on the same box? Do you see the same issue with jobs that do not connect to the database?

We use APT_CONFIG_FILE at the project level and override at the job level to point to a different config, when required. APT_DUMP_SCORE is set to True at the project level as well. Other parameters tweaked in the current project level setup (and may not apply to everyone) are the values of APT_MONIT...

This question should probably go in the "General" forum.

To answer your question, I believe that is the right one. However when scheduling your exam just make sure your IBM exam code is the right one (000-418)

Any warnings logged?
Are there any constraints on that column in Oracle?
What are the actual values you are trying to load - does it have any special characters or encoding ?

kduke wrote:One of the jobs I give away with EtlStats will take any SQL statement run it against a DSN and send it as an attachment. It is named something like GenHtmlFromSql. I tend to run the same SQL over and ...

Thanks Kim, I will take a look at this job.

Yes we are using Oracle 10g. Could you please provide me the navigation and the code to create a job in the trigger to fulfill this requirement. Appreciated your help .Thanks. A simple google search for "oracle 10g event based job" yielded some good starting points ..for example http://ww...

Is there a way to make DataStage write information out to a HTML table? I have a job currently that writes to a delimited file but I have been asked to convert that to a HTML report of sorts and email it. I believe I may be asked to convert a few more jobs as well so the solution needs to be easy en...

dxk9 wrote:I can put these into different parallel jobs and run as sequence. Is there anyother way, like using the same parallel jobs??

That might not work since if I remember correctly, the sequential stage does not support non-reject outputs when there is an input link writing to it.

HTH

But this logic is again importing the file as a single column and spliting it to various targets based on the row length right?? Regards, Divya You could split it into different columns using substring functions to extract each field as mentioned or split the file and process them downstream. Unles...

You could try the very useful ETLStats package from Kim Duke's website (http://www.duke-consulting.com/) and possibly customize it to your needs.

HTH

I'm not sure how you would export/backup a project without IS being up other than taking a directory backup. If IS does come up, you could use the dscmdexport command. http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r1/topic/com.ibm.swg.im.iis.found.admin.common.doc/topics/t_admin_backup_restore...

You could check out Oracle Heterogeneous Services which is supposed to enable access to a non-oracle database using oracle - this would require some DBA work. Hope that helps.