DSXchange

Hi,

Source is SQL Server, target is Teradata.

Source column is Unix timestamp. 1065531990.

Please let me know how to convert date and time separately.

Searched the forum but could not get exact syntax.

Thank you,

Hi All, I am using a schema file where I have used delimeter from any one this following list-- ~, |, ^, `, , But in one of the column data is coming in such a way that it holds all these above special characters(~, |, ^, `, ,). So my schema file is not able to use these as delimeters. So can any on...

Hi, Did you get the solution for the error, iam getting same type of error APT_CombinedOperatorController,3: Invalid character(s) ([x2C22]) found converting Unicode string (code point(s): 0000000000000011.000[x2C22][x0000][x0000][x0000][x0000][x0000][x0000][x0000][x0000][x0000][x0000][x0000][x0000][...

Hi, My design, Dataset-->Transformer-->TPT Stage We are importing the metadata from TPT stage, i.,e. column name with Unicode extension, since we are dealing with Chinese characters. Though the load job is finished, we are getting the below warning. TDTPT_STG_BW [IIS-CONN-TERA-005066] Conversion fro...

Thanks for the reply.

i. Time cannot be made a parameter.
ii. Can you please help in writing a routine.

Thank you

Guys,

My design

SAP BW --> COPY Stage --> Sequential File

Once it runs is should give me ProcessID_DATE_TIME.txt

Now ProcessID and Date are parameters, Time is not a parameter.

In the sequential file, how will i integrate file name with current time

Thank You,

Thanks for response, My design. Job Activity --> Execute Command Activity In Execute Command Activity in command option i gave orchadmin delete and in parameters i passed the path. Iam getting the below error. Delete_Seq..JobControl (@DEL_DS): Executed: orchadmin delete C:/Temp/t_1234_2009-02-10_99_...

Guys, thanks for the response 1. Since i cannot tell me client to install MKS Toolkit , we cannot use Shell script. 2. Our server is in Windows, for deleting a dataset should i use Server routine or Parallel routine. Both will work ? 3. We have Perl script in our server, iam thinking of running a Pe...

Hi,
Thank you for response,

Since we do not have Unix in Windows 8.1 Server, we cannot run a shell script.
What we need is from Perl script how to run Orchadmin command.?

Any suggestion will be great.

Thank you,

Thanks for the response,

but I need to write a PX routine to delete a dataset.

Thank You,

Hi guys,

I need to write a PX routine for deleting a dataset, I know command to delete dataset .,e Orchadmin delete.

But can you please guide me to write a routine for deleting a datasets.

Thank you,

Hi, Our design SAP BW Extract 4.3.2 --> Copy Stage --> DataSet When we run the jobs, we do not find the number of count from dataset. As long as your extract job completes with no warnings, you can assume that all data has been pulled out of SAP BW correctly. It is the SAP developers job to ensure t...

Hi, My design SAP BW Extract 4.3.2 --> Copy Stage --> DataSet I just select process chain from SAP BW stage and Open hub destination tab. But when i run the job its giving me below error (its in chinese) BW_Open_Hub_Extract,0: Warning: JOB_DS_BW_ZWA_TH377_EXTRACT.BW_Open_Hub_Extract: BWPACK_W_00074`...

Reason is Days worked --change float to decimal.

Resolution
Teradata data type ,
NUMERIC(p,s) is equal to DECIMAL NMUMRIC in WS DS SQL Data type.

Hi, My design Row Generator --> TD Connector When I do the test connection i getting a below error. An exception occured while trying to recive the response from the handler. An exception was received from the handler: Error loading connector library cctera.dll. The specified module could not be fou...