DSXchange

ArndW, I feel its a problem while conversion in Datastage. becoz, if we try to load data from a flat file,which contains arabic information, to database we need to mention the source NLS as 'Unicode' and then load. this process loads data without any issue. If i change the source NLS from Unicode to...

Folks, I got a work around for this. I exported the whole access data into XML and from there I loaded into the database. This process is able to display my arabic characters. ArndW, The numbers that were diaplayed are almost same which is 46. But I dont think this number is any way concerned with t...

Yes I do have NLS Enabled Datastage. I am not sure regarding my access database column character set. Arabic data is not even coded. It is clearly seen in Access. In Administrator 'MS1252-CS' NLS Map was selected. I tried SEQ & UNISEQ for Arbaic Column and a numeric was displayed in turn. rajesh

Folks, I am trying to insert data from access to a database table. I am calling this Access file using ODBC stage. All goes fine expect with one column which contains Arabic data. This is been displayed as junk data. When I try to laod the same from a flat file i am able to do by changing my NLS to ...

This too cannt be done directly. I need to MANUALLY export data from access to Excel and from Excel I need to re-export tht to text file. Then I can use this file in order to get the Arabic data. But this is a huge process as i do have lots of Access files and in each i have more than 1 lac of recor...

Folks, I am trying to insert data from access to a database table. I am calling this Access file using ODBC stage. All goes fine expect with one column which contains Arabic data. This is been displayed as junk data. When I try to laod the same from a flat file i am able to do by changing my NLS to ...

I do check tht ArndW.

i am just inserting the records. "Insert rows without clearing".

but i am dropping and creating the table everytime i run the job.

rajesh

its just a simple insert i am not even applying any constraints i have data in flat file i am trying to insert into the database. i dont have any duplicates in my source. if the records are being reject then this is because of some violation like unquie key violation or something. then in this case ...

Folks, While loading data from source to target, i see discrepancy in row counts. The no of records shown by the Designer after running the job are sometimes different when i queried against the database. Mine is a direct source---> transformer----> target JOB. the no of records in the table are les...

Yes arndW i did that too.

With "localluv" as DSN i typed "DS_Audit" in 'Name contains' tab and clicked OK.

yet it resulted "No Match Found"

rajesh

I guess we can just do a lookup using a transformer but join is different with that of a lookup

rajesh

Folks,

I am accessing DS_Audit from DS Command prompt.

IS there any way I can access this thru a mapping.

I tried using Unierse plugin with "localluv" as DSN but i couldnt see any of the tables.

Help me out

rajesh

even a direct substring function will get this.

substring(col2, 1,4)

raj

Hi Vijay

Thanks a lot dude. I never a expected such a detailed explanation. Finally it worked. really thanks a lot. :D

rajsh

<?xml version="1.0" ?> - <catalog> - <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description>An in-depth look at creating applications with XML....