DSXchange

Ooops!! This a post for a parallel job. I would not know how that would work. But the database principles should remain the same.

gateleys

Hi All I do have the 10,000 rows of data and the job get aborted while loading into warehouse after loading 5000 rows. How to hadle this situation to load it from 5001 record In Datastage PX not in server Thanks Sanjay First, find as to why the job is getting aborted. Fix that. How are you handling...

Open status view in Director, select your category. Use Filter to restrict by status if required. Choose Print from the Project menu. If needed, check the Print to File check box. Select options to suit your requirements. Ray, that will only provide information such as job start/end times, time ela...

Try using the RowProcCompareWithPreviousValue() function available with DataStage. It allows you to compare your current value with the previous value.

gateleys

Go through the packaged tutorial. Why not try to clean the Northwind database from SQL server (or any database that you have). Then create some business rules, decide what your target should contain (may something in the line of a star schema). Once you have your source and target definitions and so...

OK, that would mean if the previous poster 'Aim High' were to set warning limit to 50 for his dimensions and 1 for the Fact, then he would need to have them in separate sequence. Am I right?

gateleys

I need information as well. Can anybody please suggest a way to set number of warnings for individual jobs, rather than for all the jobs when using a sequence?

Thanks.
gateleys

A very simple way would be- if you used the NotificationActivity stage in your job sequence, you could specify to include job report in that stage. Hence, when you are notified about the success of your job via email, it will have all the information that you had asked for, namely, job start/end tim...

1) How to generate sequential numbers starting from certain values using all the above 3 functions. 2) The sequential numbers start from last value, even if i truncate the table in database and restart the datastage? Shouldnt it start from 1 as earlier. If i need it that way what should i do. Regar...

You can also use the Filter command within the sequential file. For Windows, use TYPE, and for UNIX the CAT command.

Arnd, the included list just happened to be sorted. But, what is the purpose of including @OUTROWNUM since in my actual data, the value 'Harry' could appear anywhere, and in multiple records. Further, I haven't checked, but the inFile.txt will be a pretty big file. The good side is that my to_be_inc...

I have TWO flatfiles. First, inFile.txt with a column 'LIST' which is used as the primary input, and insertFile.txt which also has a single column, 'TO_BE_INSERTED_LIST'. Sample values in the two files- inFile.txt insertFile.txt LIST TO_BE_INSERTED_LIST ==== =================== Tom Oh! No Dick Not A...

parag.s.27 wrote:Hi,

Thanks for all your help, i am now trying to write a routine with compression algo, that compresses the image.

Thanks for quick help

Please share it with us via this forum when you are done.

gateleys

Meena, you have this error since you did not specify the tablename in your database stage. If you are using ORAOCI, use the input tab and check to see the Table Name.

kcbland wrote:Okay, but how about the good stuff. Are you moving more data and using more of your server now? Are ya happy?

Happy as can be. More so because it is a realization of my parallel computation class yore. Nice to find their use. Yeah, CPU utilization has been as expected.