DSXchange

This proble was resolved.
In teradata connector stage properties,change mode from ANSI to Teradata then it works.

Thanks,

Hi, I have a scenario like 2 input stages one lookup and target stage. My source tables are like Table A col1 a b c Table B col1,col2 a, 100 b, 200 Table A (main link),Table B (reference link) connected to lookup stage. Lookup condition is continuous. Lookup stage output should be like Col1,Col2 a ,...

Hi, I am stuck with Teradata SQL query which is working in database but in datastage it is not working. My job is one RowGen connected to Target Teradata Connector stage. In TCon stage write mode is user defined SQL and SQL is DELETE FROM TEST_MOSAIC_DB.FLOWN_TICKET WHERE TICKET_RPT_DT < ( SELECT CA...

Hi, I'm having some issues in production job. My requirement is based on condition we'll load data either insert or upsert. In source Tran_type one column.If Tran_type ='IN' then insert mode. If Tran_type ='UP' then upsert mode If Tran_type='IN' then insert mode.Please suggest me to design a job to ...

Hi, I'm having 9 source tables.I'm using DB2 database as Source and Target also.There is common key for all source tables.I have two options to design a job. First One is take 9 tables DB2 stages and join them using join/lookup stages. Second One is using Souce SQL Query join all tables like this se...

Hi I'm using DB2 as source. In DB2 I wrote user defined SQL Query. select A.ACCT_NBR,A.CHKDGT,A.ACCT_OPN_DT,A.ACCT_CLOS_DT,B.ACCT_BAL_SMRY_AMT,B.ACCT_NBR,C.CR_LIM_AMT,C.ACCT_NBR,D.CR_LIM_AMT, D.ACCT_NBR from AGMNT A, ACCT_BAL_SMRY_DD B,ACCT_CR_LIM C, ACCT_FTR D where A.ACCT_NBR= B.ACCT_NBR AND A.ACC...

I used aggregate stage but it's not given required output.

Hi, In my project my requirement is merge the duplicate values into one. My source is like this: key,col1,col2,col3,col4 01, a, null, null, null 01, null, b, null, null 01, null, null, c, null 01, null, null, null, d 02, p, null, null, null 02, null, q, null ,null 02, null ,null ,r, null 02, z, null...

Hi, My source values are like : 2 3 10 100 My required target is : 002 003 010 100 Please help me how to pad zeros on left side to an integer using transformer stage. Thanks, Eswar

my source sequencial file has three attributes.
one dd-mm-yyyy format
two:mmddyyyy format
three: yyyy/dd/mm format
I wants convert string to date format the above all attributs.
How to validate and convert from string to date.
Pls help me.