DSXchange

Hi, I encountered an error while using Oracle stage, auto generated upsert option (Update Then Insert) with 248 columns. The job had 227 columns and was working fine until I appended 21 columns . Apparently, the job completes successfully with 241 columns. Does Datastage Oracle stage have any limit ...

Hi I need to update a column in database with current timestamp offset "X" number of hours (in short Current timestamp minus 7 hours). I have a job that looks like this ROW_GEN--------------> TFR------------->ORACLE_ENT I m passing the offset hours as a paramter (string). I convert this st...

Hi, Is it possible to truncate and load the table in the same job. This is the design I have now. I have the load option selected in the Oracle Enterprise Stage. I truncate the table through TOAD before I load. Seq_File---------->BusinessRules--------->Oracle_table How can I include the truncate opt...

Is your target Seq File?

Is the column nullable?

If "yes" to both then change the column datatype to "Varchar" and in the "Edit Column Metadata" specify "Null handling".

HTH
vick

Hi I have 2 lookup stages against Oracle Tables each with 47000 records. My source is an Oracle table with 400 records and my target is a flat file. I get the following error Lookup_19,0: Could not map table file "/opt/IBM/IIS/dstage0/lookuptable.20070323.3mux21a (size 759256840 bytes)": N...

Thanks DSGuru2B!!!

The network team set more space and it worked. It had space to read only 5900 records and I had 12000 records.

Sorry if I had a dumb post.

Thanks once again for all responses.

It did'nt help.

If I use the "Dont sort Previously Sorted" option then about 2000 rows out of 12000 passes thru.

Are there other options to remove duplicates?

I m trying to load 12000 records. tmp dir df -k /tmp Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd3 524288 507000 4% 689 1% /tmp Scratch Dir Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/fslv03 131072 130656 1% 4 1% /opt/IBM/IIS/scratch0 /dev/fslv04 131072 130724...

I m trying to remove duplicates while loading into an Oracle table. I get this error when I use the remove duplicates stage ---- " Fatal Error: Tsort merger aborting: Scratch space full" I checked the directory but there is space available. I have 12000 records to be loaded into the table....

I need to compare two files based on 2 sets of keys in a CDC stage . For instance

ID & S_No is the first combination
ID & V_No is the second combination

Is it possible to do that in the same run or do I have to run it twice with different key combinations.

TIA

The CDC stage I have currently works on the combination of 2 keys (ID & S_No) when comparing the 2 files (previous day file & current day file). I need to compare the files based on 2 sets of keys. For instance ID & S_No is the first combination ID & V_No is the second combination Is...

Thanks a lot folks. I think I figured that. I was doing an upsert into the table, changed it to load---->append and this took care of the 8000 odd records that were being rejected. (I think I had the wrong SQL for Insert & Update which was rejecting records) I resolved the issue with Delete code...

thanks! I have set Drop output to false for all(Insert,update,delete,copy) and set the log stats to true as well. On the DSDesigner the performance stats show 6000(rows from before FILE) and 6500 (rows from after FILE) and the target Oracle stage shows 9688 rows. But the DSDirector shows 1600 insert...

That is exactly what I did.

I checked the files as well.

There is one record that exist in before file that is not in after file.

But it does not pull the delete code for some reason.

I also set the delete code in the option.

Any pointers?

I m not getting the codes for DELETE n UPDATE.

I m getting '0' and '1' for Unchanged & Insert.

There are records in previous day file that does not exist in the current day file (which means its a delete but I dont get a code for that).

Any pointers