DSXchange

Hi,

My source is sequential file with varchar data. while doing the min() aggregation to the varchar data the, the output am getting in the hexa decimal format.

How to avoid this?

Please give me the solution.


Thanks,

Hi,

Please give the solution to avoid the below warning message.

Instruments,0: Import consumed only 103bytes of the record's 109 bytes (no further warnings will be generated from this partition)

Thanks,

Hi,

am getting the following error. How can i solve this.
[DataDirect][ODBC SQL Server Driver][SQL Server]Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

Thanks,

Hi,

I have two job flows ( One flow for inserting the table, second job for updating the table) in single workspace window in designer.

I need to run the first the first job ( for insert) and Update flow ( for update).

How to fix it.

Many thanks,

Hi,

am getting the following the following error, job getting aborting because of the below error.

APT_CombinedOperatorController(2),0: Fatal Error: Accessor type "ustring" does not match interface field type "string[max=200]".

How to resolve.

Thanks,

HI, I have the data with two columns with two rows as follows. IS_AVAILABLE_SRDR SRDR_COUNT X 5 Y 6 The output required as follows. IS_AVAILABLE_SRDR SRDR_COUNT IS_AVAILABLE_SRDR SRDR_COUNT X 5 Y 6 How to get the above output. Thanks,

Hi, am getting the data from the source file is eight characters (it may have characters as well as Numbers). Ex: OMNI6408 While loading into target table i need to filter if first three letters are characters. (If first 3 letters are numbers then only I need to load) Pl give me the solution. Thanks,

all the values are inserting into target table with exact values. if any null values exist that are inserting as NUll.
values are inserting with exact values.
Also warning is comming in log.

Thanks,

HI, am getting two input fields Date and Time in Varchar. I have converted into Timestamp format. While loading into the target table the values are populating into the table and am getting the below warning for all rows. Order_History_Stg,0: Warning: At row 128574, link "lnk_staging", whi...

Hi, Output from transformer compilation follows: ##I TFCN 000001 09:38:29(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TUTL 000031 09:38:29(001) <main_program> The open files limit is 100; r...

HI,

i am getting the two fields from source file ( one is Date field, second field is Time field). The datatype of two fields is varchar. That two fields ( Date and Time) needs to converted as combination of DateTime, datatype is Timestamp.

Pl give me the possibility,

Thanks,

the following error also one of the reason for aborting the job: Transformer_30,1: Fatal Error: waitForWriteSignal(): Premature EOF on node usvdstgd1 No such file or directory

Can you please let me know where can i disable the operator combinability ..

The Error is : APT_CombinedOperatorController(0),1: Fatal Error: Fatal error in transfer, cannot continue.

Hi,

while running the job am getting the following error:

node_node2: Player 15 terminated unexpectedly.
How to solve this, pl reply

Thanks,