DSXchange

Thanks Guru...Gereat Help .....Thanks Again [quote="ray.wurlod"]The job parameter value must be obtained before you run this job. You can create a routine to read the value from the hashed file, then use the return value from this routine in a job sequence to provide the value for the job ...

Hi,

I want to read the value from oracle thro' Datastage routine i.e. I have oracle table in which there is only one row for each object type. As per my design I want to read the value thro' a routine and then pass it to sequencer job as an return value.


Regards,

Hi, I've job which fetches only one record in Hash/Seq file and I need to use it as a Job parameter in next job. Its a Date filed and I need to query my source against it , I want to filter the data at source stage only by embedding the hash file value as parameter in the SQL query 'WHERE' clause. i...

Hi Sai,, I am new to DS, Can you please explain how to read value from hash file and read and return as status and how to pass this value in next job. Regards You need to create a stand-alone job that reads the value from the hash-file and returns as the status. The next job can then obtain this val...

Hi, I've a value in Hash/Seq file and I need to use it as a Job parameter. Its a Date filed and I need to query my source against it , presently I'm doing this in transformer-constraint but it fetches all of the data. I want to filter the data at sourcr stage only by embedding the hash file value as...

Hi , I've a job which writes to Oracle table i.e. the last job run time is written to oracle. In my next job where I extract the data from SQL server so I need to Pass the parameter of my last job run time in that. Can you explain the Utilitylastrun in detail....or there can be other design Thanks i...

Hi Vincet, I've made a job which extarcts the date in correct format in hash file. Can you please guide how to pass this value job parameter in my main job whare I'm extracting the data from SQl server. as u said Now pass the value to the SQL Server extract job as a job parameter. Add it to your SQL...

Hi, I've source as an SQL server and target as an Oracle. At end of my job I'm writing the lastJobruntime to a table in oracle. For the delta load I need to extract the data >= lastjobruntime. I was thinking to extarct the lastjobruntime in hash file and then in constraint have a condition sqlserver...

Hi, I need to insert the current date time to Oracle the target field defination is 'Date' and has the data with ti,e stamp for e.g. 6/23/2004 10:47:00 AM I tried using the TimeStamp(Date()) it gives the date date but time is all set to 00:00:00 . I need to populate the timestamp also as per the req...

Hi, I've a Scenario where I need to know the maximum number of sequnce number and then insert the new rows starting +1 of max sequenc number. I've made a job in which I stored the max number of sequence in the has h file by: SELECT MAX(USER_ID) FROM TFT_HR Now In my second job I'm using the same has...

Hi, I've a scenario: For example, say a student id record has been received that has an id#: 123 in Table A and a duration of 5 hours. 123 has 2 courses QW, PO associated with it in Table B. The record for student id: 123 will therefore be divided into 2 training records; Record1: QW with Duration: ...

Hi ,

The email is been generated by sequencer plug in i.e. notification activity (attach job log check box clicked), the problem is to make the error or failed job distinct in the email.

Regards,
Munish

Hi, I have a sequencer job which runs 7 server jobs the trigger is been set to 'unconditional mode' i.e. whatever the status is shoot an email. Now the problem is in the job log I want to make the job which has failed as bold or something outstanding so that when the support team looks at the email ...

Hi, I'm getting the row wise i/p as XML string <main><a>ABC </a><b>DEF</b> </main> <main><a>GHI</a><b>JKL</b> </main> need to break in to format as below ABC DEF GHI JKL Basically to remove the XML embedding i.e. <> </> Regards, Munish

Thanks to all , it solved the problem by pasing the dta thro' the XML writer. Regards [quote="MaheshKumar Sugunaraj"]I guess you must have the XML Input/output stage installed on your system, Once you have the file Use the XML Metadata Importer and Import the Table Definition for the file ...