DSXchange

This transformation giving me null when it should not be null Any idea why? as sql query shows data stage variable is as varOppSrcCdAdj If out_stg_capture.OPP_SOURCE_CODE = "CMPN" And out_stg_capture.CAMPAIGN_CODE [6,1] = "Q" Then "TELC" Else If out_stg_capture.OPP_SOUR...

whats the work around it? Contact dba?

hi there,
getting error below then job terminate , any idea whats wrong

main_program: A SIGPIPE signal was received in APT_JobmonFilter::writeMessage
caused by closing of the socket on port 13,400; turning off job
monitoring for the rest of the job.

This job is doing couple of lookups based upon key

Hi there i am getting these errors APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'NOTLIKELYDSCAPIOP_$KKNS_DB_NAMENOTLIKELY'. But i have all variables in place in userdefine ...

yes trying to move all but still cant find it

hi there,
when i open designer cant see my file edit stuff in there,
how can i get it back
thanks

hi there
any idea how can i fix this warning

Insert_DMT_TACTICS_FT: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.

when you say stage what that mean? using db2pxstage makes sense?

ya thats right , any way i can increase the performance for update insert
as array size 1 update insert speed is too low

Hi there, getting this warning trying to update or insert on target side in one go any idea how can i fix it thanks DMT_TACTICS_FT,0: Warning: DMT_tactics_FT_TEST.DMT_TACTICS_FT: This update action 'insert or update' is not compatible with parameter array binding. Array Size property will be set to 1.

What data types and sizes have you declared the various columns (tatic_id, opp_no, opp_id) as? Which one(s) are you using as the key(s)? tactic_id varchar2(30) same datatype for sth_tactics and fct_tactics opp_id integer same datatype for opp_dm and fact_tactics opp_no is key for left outer join var...

What data types and sizes have you declared the various columns (tatic_id, opp_no, opp_id) as? Which one(s) are you using as the key(s)? tactic_id varchar2(30) same datatype for sth_tactics and fct_tactics opp_id integer same datatype for opp_dm and fact_tactics opp_no is key for left outer join var...

Hi there, I am attaching some sample data When i build fact_tactics using left outer join it works fine (please look at link) http://i450.photobucket.com/albums/qq226/times29/outerjoin.jpg Then i tried lookup it gives error numeric values out ot range(please look at link) http://i450.photobucket.com...

Hi there, I am attaching some sample data When i build fact_tactics using left outer join it works fine (please look at link) http://i450.photobucket.com/albums/qq226/times29/outerjoin.jpg Then i tried lookup it gives error numeric values out ot range(please look at link) http://i450.photobucket.com...

Hi there, Heres the link Problem is on change capture this is star schema with dimensions as lookup based on business keys and populating fact table http://s450.photobucket.com/albums/qq226/times29/?action=view&current=capture-1.gif&t=1223081658023 and http://s450.photobucket.com/albums/qq22...