DSXchange

Hi Naren,
I went thru this post.
In my case, I need to run the sql script to get the value.
What might be the best thing to use to get that from DB and pass on to Userstatus.

Thanks and regards,
Munish

Thanks Champs, However I could not make much progress. To start with I am able to figure our how to pass on values from first job to another. But, coming back to first job. Initially I was storing the max value in sequential file. Now, if I want to store in userstatus. What type of job should I use....

Hi Ray, I tried the 1. I created Job1 which gets the max value from table. 2. Stored it in sequential file. >>>>>>> Not sure, how user status area works. This concept is new to me. Could you please provide some more explaination on this. however, I need a bit more explaination on 3. The job sequence...

Hi Everybody, I am facing a very common problem of capturing maximum value from table and using it as inital value for Surrogate Key Generator. We are using Parallel Edition. I have searched the forum but most of them is for Server addition. Could you put some light on how to take care of this in PA...

Hi Everybody, I am using Oracle Enterprise stage and using 'load' as Write mode. Volume of data is more than 100 mills per load. I need to maintain Primary constraint. As OCI stage does not like any constraint. It loads the duplicate values and if I try to use the constraints OCI falls over. ?? Can ...

Thanks Guys,
It really worked.

Closing the job.

Thanks and regards,
Munish

Thanks it worked. But still unable to load. This time Sequential_File_1,0: Field "ADJUSTMENT_KEY" has import error and no default value; data: {" 0 "}, at offset: 0 Sequential_File_1,0: Import complete; 0 records imported successfully, 6 rejected. I have checked the datatypes of ...

Hi All, I am loading target tables in Oracle. Source is a sequential file. seqFile >Oracle Enterprise Stage(TargetTable) I am getting the following error. Oracle_Enterprise_0: Indexes on table 'OLB_ADJUSTMENT_FACT' preclude direct parallel loading unless an index option is included. Add an index opt...

Hi Ray and Kumar,
Thanks for your support.
Closing the job.
Regards,
Munish

Hi Sandeep and Kumar,
Thanks for your advices.
It is the same requirement as in my other post.

Regards,
Munish

Hi everybody,
Thanks for your advices.
I will give it a go now.
Regards,
Munish

Thanks Gentlemen,
It worked in the first instance itself,
Regards,
Munish

Hi Everybody,
I have input as dataset.
Next Stage: Lookup
Final: Creating Target Dataset

I needed to trim my input data.
Could any put some light how to do it.
I am using mapping in Lookup stage.

Thanks and regards,
Munish

Yes, thats what I am using.
But my value is just one fixed number say 1 (numeric)
I am strugling to fill that column with that value (1).

Thanks

Hi Everybody, Wishing you all a very happy new year. My datasource is a dataset (DS1) created by previous job. I need to add an extra columns and pass on this as new dataset (DS2) (DS1 + new column) This new column is the one which I want to get from Lookup table. I have no column to lookup in DS1 a...