DSXchange

Hi , Im tryig to analyze why this problem exist, and only today i as able to get the Director logs, and that says: Read caching disabled, file size exceeds cache size i searched the forum for some replies. i read in a post that says, if i increase the "Read Cache Size" (mine was 128 MB). a...

But thanks Craig for your idea.

Check this one,


http://publib.boulder.ibm.com/infocent ... city.html

Hi chulett, That was a good idea. I tried to verify the issue, but i really couldnt understand why the key is not generated properly. but i found a way around to get this working. These are the steps i followed: 1) Increase the rows per transaction to a higher number (initially it was 0) 2) when the...

as you said i cleared the log, now i ahve ahardcoded all the parameters. im going to start the job again.

last_key is the previous value.(i mean the previous surrogate key that was generated)

a small update: this is the stage variable that i use:

If not(isnull(KEY_COLUMN)) then LAST_KEY+1 else 0

this works fine for all jobs that we have.

i used the following to find my job number: LIST DS_JOBS JOBNO WITH NAME = CustLdCup2OdsCustRef and this gave me the number as 2235. so my command to clear the log should be like: CLEAR.FILE RT_LOG2235, please correct me if im wrong. or can i create a copy of this job and try loading it in the mean ...

data type is Double (15-length)

Hi I have a Server job that extracts data from a sequential file and loads it into oracle table using oracle bulk loader. the total number of records is 3.8 million in the text file. And when i load the data we generate a surrogate key in the transformer (we use a stage variable - keep adding 1 to t...

try using a back slash (\) before the single quote. for example i use it like this:
\'OD\' to specify 'OD'. i hoe this works for you.

I checked cat /etl/PDAODS_Dev/temp/text.txt and this is working now, but i have one more issue, now. This text file has 2 fields, data type is double. The data in the text file looks like this: 20030125, 20080725 Ans im using a execute command stage to read these values and pass it as parameter to t...

Hi I have a server job that reads data from Oracle DB. when I run the job the job gives me 15994 records (i mean the job extracts only 15994 records), but when i runt he same query in toad it gives me 16018 recods. i checked the job in director, it dosent have any warning in it. i do not see any pro...

Hi I have a issue when im reading from a text file. This is a job sequence. Job1 (J1) creates a text file with one row. (out put of j1 will be 1234 just a number). then i use a execute command stage to read this value from the file. The command is cat and in the parameter i have given /<path_name>/<...

I think you will not see the Partition symbol in this case. I tried the following. case1) RowGenStage---->Transformer----->ODBCStage in this case the partition for the transformer is "same" and the partition for ODBC is also set to same. I didnt see any partition flag (Link Mark) in the li...