DSXchange

It logs the same message as warnings when I run the job.

When I am trying to view data through DRS Stage, it's throwing an error "Metadata mismatch for column X, Datastage column type and database column type differ".

I missed the server forum. But after the search I came to know that in server if we change the datatype to Timestamp it work's fine, but it didn't worked for me in Parallel. I don't know if that makes any difference but just mentioning it. In another post it was mentioned, ODBC cannot recognize SMAL...

Hi, One of the column data type is defined as SMALLDATETIME in SQL Server when I imported it into the Datastage it changed to CHAR(16). When I am trying to view data through DRS Stage, it's throwing an error saying "metadata mismatch, Datastage datatype and database datatype differ". I tri...

We are calling a DB2 Stored procedure from Stored procedure Stage. One of the output field from stored procedure which is an amount field is defined as (PIC S9(09) V99 COMP-3), I used the data type as CHAR for this output field in stored procedure stage, I am getting a blank value in this field. I e...

The reason I was trying to avoid using remove duplicate stage is because this is an existing code and I am trying to avoid adding stages. What I did was, in transformer I did Hash partitioning and perform sort but didn't checked the stable and unique check boxe's. Key1 (Sorting,partitioning) Key2(So...

Thank you much, you are right I tested with only key 1 and key 2 and it worked just fine, removing the duplicates. I guess I has to use remove duplicate stage and retain the first record. After the transformer stage I will use the same partitioning in the remove duplicate stage and retain the first ...

Its first and second keys, both of them.

Hi, I am trying to remove duplictes only using Transformer. In the input tab of transformer I am doing hash partitioning and doing perform sort. On one of key I am doing sort partitioning and then on other key I did just sorting Asc and then other column I did sorting Descending. Key1 (Sorting,parti...

I saw a note in PDF saying, If you have defined columns on the Columns tab, make sure these match the schema file. Could you please recheck this.

In stage properties tab in Lookup stage change the execution mode to sequential. But I am not sure.

Try to check with IsNull() function and put '', same with the varchar too.
I may be wrong because I never worked on Oracle.

Hi Ray, The target, I tested with Dataset and Sequential file. I even tested with datatypes integer, decimal and double, its writing out Zero for Alpha Characters. Job is finishing ok with no warnings, but its giving an informational message. APT_CombinedOperatorController,0: Numeric string expected...

when i send characters for datatype column SmallInt it always giving me Zero as output.
But when i hardcod as '1'or '2' ' its giving me correct result.
That explains some thing which i dont know. Thanks.

When I tried to insert a character 'Y' into Smallint datatype column, i thought it would throw an error because the datatype is small integer but it hasn't, am i missing anything? I did a test jobs around this, In transformer column derivation I hardcoded the value as 'Y' which has SmallInt as datat...