Search found 93 matches
- Thu Nov 10, 2011 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to remove duplicates using LastRowInGroup?
- Replies: 4
- Views: 2220
How to remove duplicates using LastRowInGroup?
Hi, How to identify duplicates using LastRowInGroup() in the Transformer? My input data is ID EFF_D NAME COMPANY 1 2001-01-01 ABCD TET 1 2011-01-01 ABCD TET 2 2001-01-01 XYZ TS 3 1999-01-01 PQR WRO My output data should be ID EFF_D NAME COMPANY duplicate 1 2001-01-01 ABCD TET N 1 2011-01-01 ABCD TET...
- Mon May 23, 2011 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The string contains an untranslatable character
- Replies: 1
- Views: 3896
The string contains an untranslatable character
Hi, I am getting the below error TDC_EPRS_GPC_CLAS_E,0: RDBMS code 6706: The string contains an untranslatable character. SQL statement: USING (LD_SEQ_I INTEGER, EFF_D DATE, NVLD_REC_C CHAR(3), LD_BTCH_I INTEGER, FD_BTCH_I INTEGER, GPC_CLAS_I INTEGER, GPC_CLAS_N VARCHAR(300), SEG_SRC_I INTEGER, FMLY...
- Fri May 20, 2011 6:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data truncation is happening
- Replies: 5
- Views: 4768
- Fri May 20, 2011 5:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data truncation is happening
- Replies: 5
- Views: 4768
- Thu May 19, 2011 10:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data truncation is happening
- Replies: 5
- Views: 4768
Data truncation is happening
Hi, I am unable to view data from the DB2 source stage. It is throwing the below error. DB2_COLR: The size specified for column 'COLR_N' (16) is less than that of the source table column (50);data truncation may result. DB2_COLR: The size specified for column 'CRTE_TS' (16) is less than that of the ...
- Mon Sep 27, 2010 11:31 pm
- Forum: General
- Topic: Referenced Shared Container has been modified
- Replies: 1
- Views: 1758
Referenced Shared Container has been modified
Hi, I have imported a job created in DataStage 7.5 to DataStage 8.1. This job has a number of Shared Containers. I modified two of the Shared Containers and compiled the job. The job got compiled successfully, but when I try to run the job, from the designer, it says 'Referenced Shared Container has...
- Thu May 20, 2010 11:13 pm
- Forum: General
- Topic: Special character being ignored by Oracle Stage
- Replies: 4
- Views: 2407
Special character being ignored by Oracle Stage
Hi,
I have a simple ETL flow.
ODBC Stage--------> ORA Stage
The source has a special character(similar to ' ) which is read by ODBC stage but being replaced by a reverse question mark symbol in the target by the Oracle stage.
How to avoid this?
Thanks in advance.
Deepa
I have a simple ETL flow.
ODBC Stage--------> ORA Stage
The source has a special character(similar to ' ) which is read by ODBC stage but being replaced by a reverse question mark symbol in the target by the Oracle stage.
How to avoid this?
Thanks in advance.
Deepa
- Mon Apr 12, 2010 3:54 am
- Forum: General
- Topic: routine and the error in compilation log
- Replies: 3
- Views: 4176
- Thu Apr 01, 2010 3:21 am
- Forum: General
- Topic: Change data Capture Warning[api/transfer_rep.C:1832]
- Replies: 8
- Views: 5043
- Tue Mar 30, 2010 10:30 pm
- Forum: General
- Topic: Change data Capture Warning[api/transfer_rep.C:1832]
- Replies: 8
- Views: 5043
- Tue Mar 30, 2010 10:08 am
- Forum: General
- Topic: Change data Capture Warning[api/transfer_rep.C:1832]
- Replies: 8
- Views: 5043
- Tue Mar 30, 2010 10:06 am
- Forum: General
- Topic: Change data Capture Warning[api/transfer_rep.C:1832]
- Replies: 8
- Views: 5043
- Tue Mar 30, 2010 7:24 am
- Forum: General
- Topic: Change data Capture Warning[api/transfer_rep.C:1832]
- Replies: 8
- Views: 5043
Change data Capture Warning[api/transfer_rep.C:1832]
Hi, I am constantly getting this warning while using the Change data Capture Stage: When checking operator: Defaulting "PD_GRD_EFF_DT" in transfer from "beforeRec" to "outputRec". [api/transfer_rep.C:1832] I have 5 columns in Reference link and 6 columns in Primary link...
- Tue Mar 23, 2010 12:10 am
- Forum: General
- Topic: Inaccurate Record counts on links
- Replies: 11
- Views: 4786
- Mon Mar 22, 2010 10:47 pm
- Forum: General
- Topic: Does the SORT order change due to Partitioning?
- Replies: 6
- Views: 2578