DSXchange

Hi all,

I have a job which is sending data from a file to target.
After the job run I need to maintain a stastics table which should contain the following information.

1-file name
2-job name
3-start date
4-no of records processed
5-no of records rejected

can anybody suggest how to acheive this.

Hi All, I have a server job that generates an XML output from a database table based on an XSD. I have 50 records in the test table and all of them have unique Keys. In one particular instance i have 3 records that have the same data for all the 20 columns. The output of 97 records look fine <Rec1> ...

Hi All, I have a server job that reads from a Database table, applies some transform and then outputs to an XML Output stage. The XML Output stage is designed to generate output based on an imported XSD. I need to output a particular value if the schema definition has a specific rule for a column. e...

Hi All, I have the source data like this sid,sname,recv_date,no_of_records,ind ---------------------------------------------- 1, A, 09-may-2007,800, 1 2, B, 08-may-2007,700, 1 3, A, 08-may-2007,900, 1 4, A, 07-may-2007,600, 0 5, B, 07-may-2007,400, 0 ------------------------------------------------ ...

Hi all, I am facing some errors in the stage variable derivation stage. My source data is like this code name --------------- A USA B Uk C AUS ---------------------------- I want the out put in the condition that if code=A then name should be AAA.For this I have used the stage variable as below. inp...

Hi All,

I have managed to work around this by doing the job in EE instead. Same SQL, same job set up.. but in EE it works! :shock:

Thanks Nick - I will give it a go and see what happens.

Cheers

My requeirement is like this

my input data for a particular column is like 02-feb-2007 its date-time data type.

I want the out put in 20070202 format
So can I use that iconv or oconv function in the parallel extender or is there any other method for this please suggest.

Thanks Brian. I don't really want to update the key - I really want to just say: Is code field on table? If yes, ignore and continue, if no... store the new code in the table. Basic overview is that the larger table is updated everyday so that it will always contain data for all codes. The single fi...

Hi all,

Can anybody suggest me how to call a sdk category routine in the column derivation stage of the transformer.

For example in the date catagory of sdk there is a routine called DateGenericToTimeStamp.I want to use this routine in the derivation stage.

Hi,

Thanks to all.
I gave the command as . /data/script and 777 permission to the script.
Its working fine now.

Hi All, I have stumbled across some very strange behaviour using an ODBC stage in a Server job that I hope someone might be able to help with. Basically, the job I have takes an input sequential file and loads to two different ODBC stages. One table contains all the fields in the input, the second c...

I gave full path for the file skey.txt in the unix script. Then after running the sequence I am getting following log report. -------------------------------------------------------------------------------- mail_alert_seq..JobControl (@Execute_Command_11): Executed: /data/skscript Reply=126 Output f...

Hi Craig, In the log it is showing that sequence job is finished. But the script is not getting executed. I am able to run the script in the unix env and getting the result properly. This is the log report I am getting. ---------------------------------------------------------------- mail_alert_seq....

Hi , I have to perform the sequence job bcz there is another job which will remove one file after executing the script. In the exec command stage I tried basic unix commands like rm,cp and its working fine,but to execute the unix script while giving sh /data/script1.txt command I am not geting the r...