DSXchange

Thank you very much Ernie !! I need some more clarification.Please correct me if i am wrong, my input will be Oracle stage, as the data is present in tables and i need to send these data to filenet through their webservices, will the below design fine (i didn't get the webservice, otherwise would ha...

Hi, We have the following requirement. source table struture e_no date e_n e_code e_catg e_sal src 1 1-Jan-08 a aa 100 abc 2 2-Jan-08 b bb ab abc 3 3-Jan-08 c bc 200 abc the lookup table structure is src variable value s_d e_d abc e_code zz 1-Dec-08 28-Dec-08 abc e_catg zzz 2-Dec-08 abc e_sal 1000 3...

through webservices. I am new to webservice pack of DS. While loading data to the Database, parallely we have to load the records into Filenet by calling their webservices. The job to load the Database is already created in PX. Using WSTransformer will it be possible to take the input in table struc...

My requirement is to extract the table name and field name from the database (Oracle) of the source record. We have not stored the table names and fields in the database. i.e.say my table name is EMP which has the following fields EMP_NO, EMP_NAME and EMP_DEPT. I just wanted to know is there any fun...

and field name of that table in its condition. Appreciate greatly if you could let me know about the variable or function in DS to get table name and Field name

Thanking in advance !!

hi, I like if there is any option through which we can track who made changes to the DS jobs, say if a person A created a JOB A and it's been modified by Person B on XX date and Person C on YY date. Is there a way to get this information from DS using Director, administrator, designer or manager. Ap...

Hello All,

thanks for all your help on this, i will try to implement the solution provided by you guys, will let you know if i need any help on that.

thanks

Hi, DS has to communicate with another application through webservices. For this I think we need to use DS RTI Component, as I never used it before I need help to understand how it works and wheather it's similar to Parallel Extender. 1) Will DS RTI operate in parallel mode or will it work only in s...

Hello Chulett, Thanks for your reply, can u please help me with the information about performance of the RTI job, and if parallelism is possible in RTI. Briefly, RTI bolts on to either PX or Server jobs, allowing you to expose either as a service or leverage services inside either. And yes, it does ...

Hi, DS has to communicate with another application through webservices. For this I think we need to use DS RTI Component, as I never used it before I need help to understand how it works and wheather it's similar to Parallel Extender. 1) Will DS RTI operate in parallel mode or will it work only in s...

Hi, Thanks for your reply, we are getting 3 different control files and 3 different data files for 3 different dates. We need to load extract date from the control file so we can't use file pattern as we have one control file for each data file. You can use the file pattern to read from the multiple...

Hi, We have a requirement to do a loading from multiple source files i.e. the source system will send data based on extract date, if the extract date is less than the sysdate then we need to load the file as the reload process. Say if the sysdate is 05-Dec-2008 and we receive 3 different files from ...

Hi, We have a requirement to do a loading from multiple source files i.e. the source system will send data based on extract date, if the extract date is less than the sysdate then we need to load the file as the reload process. Say if the sysdate is 05-Dec-2008 and we receive 3 different files from ...

Hi, The requirement is to load surrogate key in the target table to maintain the uniqueness in the target table. Daily we need to run this job and new records will be loaded to the target, i like to know if datastage will save the last generated the surrogate key during it's last run and increment t...

Hi, Can anyone help to understand if there is any function in datastage to get the working day of last month i.e. say the month end is 31-May-2008, then we need to see if the month end day falls on weekend if so we need to get the friday(30-May-2008) and pass it to the target. In this example 31-May...