DSXchange

i am using enterprise edition only but still not able to see the parallel maps and locales

Dear Ray,

I am not able to find any parallel maps and locales in datastage administrator.but i am able to see server maps and locales.

what will be the possible reason for this

Dear Ray,

I did not have the character set with IBM 1256 in Administrator in order to load that map for windows arabic.

regards
rd

Dear Ray,

MS1256 is got loaded in administrator but giving error if i take this as nls_lang while i execute the datastage job.

DEAR Moni, Parameter nls_lang =AMERICAN_AMERICA.AR8MSWIN1256 do i need to this setting in Windows registry/DB/Datastage? Default map for stages in the parameter NLS tab = windows-1256 is windows -1256 is MS1256? if it is the case ,i am getting error while using this map at target level. Default Coll...

no one do response for this to answer my query .

My source is sqlserver and target is oracle i am doing the below settings at source and target level for nls source : nls_lang=utf8 target : nls_map=ms1256 while i try to execute the job it is giving fatal error : FATAL ERROR (APT_CharsetConverterRep::initConv()): MS1256 is not a valid codepage. can...

yes chullet,

i have search for the same and i found 2 topics but no required information peratining to above questions

can you please guide me here

Hi

This is got resolved and i need to use alias for service_name

thanks
rajesh

Hi Some of fields in source database sqlserver is having arabic characters which i need to set character set in datastage . what would be the ANSI CODE PAGE i can use for tarabic and how can i change from default code page 1252. What about client server map i need to use for arabic characters? I als...

Hi You please first check TNSNAMES.ORA in ORACLE_HOME\NETWORK\ADMIN if it is windows. You can find Alias for the Service_Name or SID in that file. while connecting to ORACLE at Database source name : Give the alias namebut not the actual service name/sid. example: ECUST = (DESCRIPTION = (ADDRESS_LIS...

Hi Sai and Nag, Thank you for the response. I understood your concept of transformer in order to have different meta data in source and target as we can change the metadat in transformer if i am correctly understood. But we can do the same usin modify where we can achieve the perforamance. here if i...

why do i put transformer?
here i am facing diferent issue not data conversion

Hi I have two diff databases with source sql server and target oracle db i have different metadata source and target tables in both the systems when i ever i try to load columns in target table from oracle ,i ma losing the actual metadata from source table and replacing with target metadata. how to ...

Hi

I am getting the error TNS 12557 Protocal adapter not loadable after setting proper oracle_home .

regards
rajesh