DSXchange

[Why not try manually changing the metadata] Hi Chulett, Even if am changing it manually to numeric or bigint, i am being able to view the data. The only way i am able to view is by converting that to Char by using TO_CHAR function in user defined sql query itself. The data type is number at databas...

Hi Chulett,

thanks for the info.
please tell me way to find the solution.

Or Can i revert back to my superior that its not going to work with DS PX.

Hope to find some answer which i can tell me to my boss.

thanks in advance.

Hi All, I am having a column defined as "long" datatype at the Oracle source level. I am using Oracle Enterprise Stage and not being able able to import the Metadata through Orchestrate. Even while i am changing the data type to Longvarchar and using function To_Char at the Oracle Stage i ...

then how to handle this situation Ray?

I tried with both write method as load and upsert.

Please show some way to resolve this one.

I am getting the error where my column value is exceeding the default value [38,10]. job error is : Fatal Error: APT_Decimal::assignFromString: the source string (322665901919233341505776723281119128249 ) is out of range for the decimal with precision 38. I am able to read the data in source only af...

I am also getting the error similar like the one above............ but in my case my column value is exceeding the default value [38,10] job error is : Fatal Error: APT_Decimal::assignFromString: the source string (322665901919233341505776723281119128249 ) is out of range for the decimal with precis...

thanks for all the inputs you have given.
i was able to resolve this issue by converting that to char by TO_CHAR in the user defined sql.
I don't know why it behaving like that, but i am bein gable to get the required result.
thnaks a lot to all of you.

thanks for all iputs you have given.
i was able to resolve this issue by converting that to char by TO_CHAR in the user defined sql.
I don't know why it behaving like that, but i am bein gable to get the required result.
thnaks a lot to all of you.

hi All, i am trying to import the metadata of the table by load->import ->Orchestrate Schema Definition. After giving the Credentials there i am getting the error as " Cannot get the Schema Definition for requested Database Table ". When Checking the "output from server command" ...

SELECT CLMNT_ID, SBSCR_ID, CLMNT_FST_NM, CLMNT_LST_NM, DEPN_NBR, TO_CHAR(CLMNT_BTH_DT,'YYYYMMDD') CLMNT_BTH_DT, GDR_CD, CLMNT_REL_CD, DATA_SOURCE_CD, MIDL_NM, INDV_ID, MBR_ID FROM Tablename the above is the SQL query i am giving through User defined sql in ODBC stage. CLMNT_ID is the KEy column in t...

Ray, Thank yiu for your response. When I am executing the query in the database I am not getting any rows, meaning there are no duplicates in the table. But then, the odbc stage is giving me the same value for the PK after 40 rows, other column values are changing. I dont know why this is happening,...

i tried with importing the table definition and it is still gigving the same problem of duplicates.
My table has only one primary key.

Hi All, I am facing a problem while using ODBC stage in my job. i am getting duplicate records while retrieving the data through ODBC stage for a primary key column in database. In data base the column is the key column and i am checking the key option in ODBC stage. I am getting the same value of t...

thats also not working,

can any help in that?

thanks in advance.

am doing both of the things and i am facing problem in "decimal" as i have changed all my numeric n integer data types to decimal for the data validation purpose. the following error msg i am getting When validating import/export function: APT_GFIX_Decimal::validateParameters: the decimal ...