DSXchange

Hi rajngt,

Thanks for your reply.

Still 2 records are writing to the temp file.

Is there any other alternative way to acheive this?

Thanks
tom

Hi Dsxians, I have a requirement to check the date column value is same for all the records from source file using transformer stage in the extract job. For eg: run_date 01/23/2008 01/23/2008 01/23/2008 01/23/2008 01/23/2008 If it is not same for all the records,I want to stop the process. I tried w...

Hi Dsxian's I am creating xml xpath expressions using meta data importer.When i am saving the metadata it is throwing below error. Error calling subroutine.DSR_RECORD Check whether the datastage is set up correctly. connection is broken. Failed to write Datastage Object("System._Comobject"...

Thanks for your response ray. Zeroes are getting truncated when opening the output CSV file with Excel.I could view the data with zero's in vi editor.Datasage is not truncating. I am writing this column as string datatype only. Could you please let me know why zero's is truncating when opening with ...

Hi, When I am writing to a .csv file through datastage with varchar data which contains the value as 0000018 0000019 0000020 0000A10 It is truncating to 19 19 20 0000A10 I could view the data in editplus without trucation of zero's.If the data contain any alpabetic character then is writing properly...

Thanks chulett for your help. My problem got solved after setting the NLS_LANG environment variable value as AMERICAN_AMERICA.AL32UTF8 in the administrator client. Can any one please clarify these questions. 1.)Why we need to give as AMERICAN_AMERICA.AL32UTF8 to NLS_LANG ,where oracle NLS_CHARACTERS...

Chulett,

Thanks for your reply.

While querying NLS_DATABASE_PARAMETERS I can see value of NLS_CHARACTERSET which is set to AL32UTF8 and NLS_NCHAR_CHARACTERSET to AL16UTF16.

Thanks
tom

Hi chulett, Thanks for your reply I set this value as NLS_LANG=AMERICAN_AMERICA.UTF16 in the userdefined environment variables of my project and in my job set as NLS_LANG=$PROFDEF I could see NLS_LANGUAGE as AMERICAN in oracle DB using the query. SELECT * FROM NLS_SESSION_PARAMETERS; NLS_CHARACTERSE...

Hi Arndw Thanks for your reply.After setting NLS_LANG user defined environment variable in my project and while using in my job I am getting the below error ORA_BM_INSERT: connect failed for env: EIM_D, user: etl_load, password: ***** Oracle error: -12705 ORA-12705: Cannot access NLS data files or i...

Hi ranjini,

In the excecute command activity stage

in command give value as

sh -c

and in parameters give value as

"cat filename"

pass this value as a parameter to the next jobactivity stage for the desired job using the code .

Field(EXC_Read_Seqid.$CommandOutput, @FM,1)

HTH
tom

Thanks john for your reply .I tried with NVarchar as a datatype to this column,but still the character is not inserting.

Thanks DSGuru2B.I will follow up with the thread you provided.

Thanks for your reply DSguru2B.I understood your point. Could you please suggest some performance enhancement techniques for change capture stage which has around 200 and 400 million records in before and after dataset? Reading these two inputs data to change capture stage is taking abt 4 hrs. input...

Hi Dsxians, I am joining two tables from an oracle db using join stage, each input link contains 2 million records.Inputs are sorted and partitioned on key columns.In the job monitor i could see that all source records from the input links are read first and then the starts the join operation. Could...

Hi, I couldn't read a from an excel sheet using java client source stage throwing the below error. Fatal Error: Fatal: ExcelRead: Problem opening filejxl.read.biff.BiffException: Unable to recognize OLE stream I had given the following properties in my job filename- Sheet- TopLeft- BottomRight- and ...