DSXchange

By setting the rows per transation to zero in the tab "transaction handling", you can make sure the commit happens only at the sucessful completion of the job. In this case you need not worry about deleting records etc. But if the rows per transation is set to > 0 then, 1) one way to do it...

Hi, In case you have set Rows per Transaction (Commit level) to be greater than zero only then you would run into the problem of having records in the target table before it aborts. you would probably need to think about deleting all records(or records of that particular) in the target in case of an...

3 sort columns and everythig else have default values

i have a simple transform and a sort in the container. The log shows that the processing happens pretty fast till the SORT. I process a couple of thousands of records.

Hi, I use SORT STAGE to sort the sequential file that is generated by my job. Just this stage itself takes 1 to 2 minutes. I did not get any improvement in performance even after giving a temporary directory (not sure whether it does improve performance in the first place). Any suggestions. thanks, ...

Hi Neena, My understanding of using Excel as a source and/or target was that the DSN points to the WorkBook (.xls file) as it does to a database and each sheet with the workbook is considered as a table. In short Database = Workbook (File.xls) Table = Worksheet (sheet1) Now If i remove the .xls file...

Finally I was able to write to excel. :D But to drop table/worksheet before load or clear the table/worksheet before load does not seems to be working. It throws errors like DSD.BCIOpenW call to OCONV failed. Statement: DROP TABLE accountloader Deleting data in a linked table is not supported by thi...

If excel is not installed in my DS server, would it pose a problem in writing to an excel?

I am using ODBC stage and trying to write to an excel file. The DSN is mapped to excel and the worksheet chosen as the table. But when trying to write to the excel Event #:504 Timestamp:8/12/2004 3:58:15 PM Event type:Warning Message: Accountxls..ODBC_4.Lnk_Account: DSD.BCIOpenR call to SQLExecDirec...

I was trying it out as a first step with a .pdf file. i used the folder stage and tried to read data at a particular position. it threw me the following error

record 'Basic.pdf' contains characters which are not defined in the file's NLS map

how to define a file's NLS map?

Hi, I know this is a fairly impossible question. But thought I would ask before making any decision :( My source can be a .gif / .tiff or a .pdf file. Does datastage have the capability to parse such a file retrieve data from the same. eg. My source is a scanned copy of a offer letter. Can datastage...

thanks guys

but the issue is collecting all the records back to a sequential file. the moment i split them i end up overwriting the file. Its not a DB table.

Hi, A single row from the target needs to be inserted as two different rows with a column having two different values . Eg Row of the Source Item : Product 1 Type : Vehicle Item : Product 2 Type : Truck The 3 rows of the Target for the above input 1. Item : Product 1 Type : Vehicle 2. Item : Product...

Using aggregator stage to find the rows with duplicate columns values is one other method that I used. I used the count(coulmn value) > 1 condition to identify the key columns that are being duplicated.

Hope it helps