DSXchange

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...

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...

Is it? Oh my mistake then. I did not know that.

In DS 8 there was no such requirement. Still getting used to DS 8.5.

No that did not help.

Although, if you arrange the columns in the Custom SQL same as the order in the Metadata, that works!!

A silly solution, but a solution nonetheless

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 ...

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...

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

After modification, the compiler is throwing this $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF JobNmTrimed = Trim(JobName,' ','B') handleJob = DSAttachJob(JobNmTrimed, DSJ.ERRFATAL) If NOT(handleJob) Then Call DSLogFatal("Job Attach Failed", "JobControl") Abort End...

I gave the same order. The warning still persists.

Same data types but different order.

I have it in my Before link as well. Even when I include it, it throws be the same warning as I have not put it under Change Value nor Change Key.

I don't want to compare that column and its not a part of the key but I want it from my After Link.

I have it in my Before link as well. Even when I include it, it throws be the same warning as I have not put it under Change Value nor Change Key.

I don't want to compare that column and its not a part of the key but I want it from my After Link.

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...

It is working fine except when the first stage is a Dataset. It keeps giving incorrect record count.

Hi, I am getting this error while using the Change data capture Stage CHCP_SRC_TRGT: When checking operator: Defaulting "SYS_CD" in transfer from "beforeRec" to "outputRec". [api/transfer_rep.C:1832] SYS_CD is present in both the input links, and neither used as Change ...