DSXchange

sure ..thanks !!!!!!!!

Its your responsibility to avoid the duplicates in the reference data for getting proper result . @pandeesh, FOR example Here, Inner join SC as key Source : for 10,000 records CC -USA is and SC| is distributed as below: 1000 Records:IL 1000 :NY 1000 :PA 7000 :TX..............(.Total 10,000) Referen...

@stuartjvnorton,Kryt0n Thanks for the Input Is the state code on the source side trimmed? If you've got trailing spaces, then nothing will get joined? I am using a text file ..Not trimmed ..trimmed it Are you sure both the source and reference data are getting read in properly? checked it to read it...

Hi , I have source data: CC (country code)|SC (state code) USA|IL USA|IL USA|NY USA|NY USA|TX USA|TX Reference data: SC|DESCRIPTION IL|ILLINOIS TX|TEXAS NY|NEWYORK NY|NEW-YORK reference (sequential_file) >>> Inner join (on key SC)>>>>output(sequential_file) source(sequential_file) Out put : CC|SC|DE...

Hi , Still I am trying to understood your problem :) why i am not able to see the Column 4 - STP for txn ===>Null, Let me try this way: Out put data : col1,col2,col3,col4 row1..3 a,b,c,- row4...11. n,m,d,g This can happen ..means "no value" for col4 for "3 rows".."value is d...

Hi,

Can you able to "view data "for the "Column 4 - 'STP' "..?? do a "mapping as-is .i.e..straight mapping "

There shouldn't be any problem ..

Thank you

DataSet(the Dataset Comes from an Extract Job) =====> Transformer =====> Seq File Hi, Please make sure your mapping is proper .. you can always check your transformation logic by writing it to PEEK stage source >>xfm (apply transformation logic for the field)>>peek stage This way you can get more c...

Hi vskr72, Please be specific while mentioning source and target details ..rather than table ..EX:Oracle,DB2 .. 1.Nullability check /requirement varies depends on your meta data of your fields..fields meta data details (EX:date fields,integers...)?? 2.Mentioned here that it is working fine in one en...

Hi Everyone, I am using DB2 API stage to read the data with with "custom sql query".. job..EMP_MTH: [IBM][CLI Driver][DB2/AIX64] SQL0206N "PRD_LN" is not valid in the context where it is used. SQLSTATE=42703SQL0206N "PRD_LN" is not valid in the context where it is used....

@chulett

Thanks for the reply

The given SMTP Server name ..is the location where "DS server "installed But I am not sure SMTP work's this way ..i.e local connection to the Server

Unfortunately ,I am only the admin because its on my work station (personal computer)

Hi Everyone, I am getting the same error as here but I am not sure whether we can post in the much older topic :? job_activitity1>>job_activitity2>>Notification_Activity Here the client and server machine's are the same..Windows 2003 *** Output from command was: *** SMTPMail Looking up server... SMT...

Hi qt_ky ;

I tried that option too..same error message

thanks for the reply

I am welcoming more ideas here !!!

Hello Everyone; [ seq_file >>>>sort1 stage>>seq_file2 ] Input data: CuSTID|CNAME|CITY 1|MIKE|NY 1|TIM|NC 1|JOHN|MI 2|TOM|MN 2|KEVIN|LA Output data:(format should be) CuSTID|CNAME|CITY|keyChange 1|MIKE|NY|1 1|TIM|NC|0 1|JOHN|MI|0 2|TOM|MN|1 2|KEVIN|LA|0 Sort stage :- sort key=CUSTID ,sort mode=Don't ...

Nothing else other what I mentioned is here .. But in my command line (Putty)showing following message "DS_JOB Name to execute: RUN_ID for the job is:XXXXXXXX Invalid arguments: dsjob -jobinfo [-useid] <project> <job|jobid> Status code = -9999 DSJE_DSJOB_ERROR " Thank you

I have given but It's the same log message I am getting !!!