DSXchange

Thanks Ray..

Update timestamp should be in min and max times range..

Below is peek o/p Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874 Peek_422,1: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874 Peek_422,0: MINIMU...

Hi all, I am trying to range look up..on the reference link.. My input source column is updatetimestamp field looking up between mintimestamp and maxtimstamp fields in the reference getting the datadate value.. Range expression is as below.. the job is running but not correctly the datadate value is...

Oh ok thanks but not able understand what I am missing and how solve the issue..

even though the sort and remove dup keys are different now,After including the ENV variable APT_NO_SORT_INSERTION to yes warnings were gone..

So just trying to understand what does this do or mean?

remove dup keys are same as sort stage keys...

Getting following warning and couldn't fix it.. any help appreciated.. RmDp_3: When checking operator: User inserted sort "Srt_3" does not fulfill the sort requirements of the downstream operator "RmDp_3" Used same partition method and keys in rem dup stage. In sort stage with sa...

Hi All, INSERT_NSTAR_LOGGING_CATEGORY_CROSS_REFERENCE: Process meta data not available in database I am seeing above message and some warnings below..but don't have join stage though in the job.. Jn_Join_318: When checking operator: Dropping component "UPDATE_USER_ID" because of a prior co...

Check the data type in the database table. Check the data type in your job's metadata. If you're using a Connector stage, change the "Fail on type mismatch" property from Yes to No. ... Thnks Ray .. not sure where to set this property though .. I 've ODBC connector for Netezza lookup and ...

Check the data type in the database table. Check the data type in your job's metadata. If you're using a Connector stage, change the "Fail on type mismatch" property from Yes to No. ... Thnks Ray .. not sure where to set this property though .. I 've ODBC connector for Netezza lookup and ...

Hi ..

I am getting below warning..

main_program: Fatal Error: Type mismatch for field 'ACCOUNT_VALUE_ID'. Fatal error.

But couldn't find type match from the table and the job.

Any thoughts on how to find out or debug it?
Thanks!

Thanks Andy !

Hi All , I am getting the following warning max_daily_position_id: Schema reconciliation detected a size mismatch for column KEY_LABEL. When reading database column INT32 into column VARCHAR(min=0,max=1), truncation, loss of precision or data corruption can occur. But KEY_LABEL is a dummy column wit...

Hi ,

Is it ok to trim the Numeric/Decimal fields from a sequential file and load to Numeric/Decimal fields on target database?

Thanks

Thanks Mike and Craig !!

this worked...

If IsValid("Date" , DSLink2.OPEN_DT, "%yyyy%mm%dd") Then StringToDate(DSLink2.OPEN_DT,"%yyyy%mm%dd") Else SetNull()