DSXchange

Hi, I have one Issue,Everyday I need to process 1 Sequential file. First I need to check the size of the fille. If the records in the file less than million records then I have to Stop the process, else I have to continue the process. The process Involves,I need to compare Today's Input File with Ye...

Raja,

Thanks for the reply, could you please tell me little more detail,as i have to do this in my work. please help me out,

Thanks in Advance
vkr

RAJARP wrote:hi ,
I had this requirement once.i used a routine activity with 'DSJ.LINKROWCOUNT ' to achieve that.

Regards,
raja R p

Hi flokes I have an issue.. In my job sequencer I am unsing email notification activity. In this activity I have attached job repot and sending it mangers. Now they are asking me to send me only part of the report like total records processed and total records missed instead of job report. How can I...

In the Sequential file stage, you have a property under Options "Read First Rows". Set the value of this property to a job parameter and you should be good to go. Hi, Thanks for your response.Could you pelase tell me how can we set ReadFirstRows value as a job parameter.Please explain me....

DS Friends, I have an Issue at my work.Please help me if you have the solutuion and suggestions to solve my problem My issue is .. I have a job that process on .txt file. This file contains more tham Million records. I need to set a parameter to job to stop after processing certain number of records...

sunitha_cts wrote:Thanks Cris

Yes, we can remove duplicates using sort stage and also every output link..but make sure that your partition type is other that auto and select perform sort and unique.. that will give you unique records..

hope this makes sense..
krishna

Craig, Being Server edition, I did think about deleting or including a constraint to skip 37. But that is on the assumption that the target is direct load of source with no other dml or "prev-n ... Sainath. since i am not a Premium member i can not view this content.. could you plase give me t...

Hi, I have an issue with my server job. I have one job that runs every day to load data into target file/table. Job faild after loading some records in to target, ex.. assume that i have 100 records in my input, job failed after loading 37 records, next time i have to start loading from 38 record. h...

DS Floks and Gurus I got a new project in Datastage with siebel integration.I've good knoweledge in datastage,but never get a chance to work in siebel integration. Could any one send me the datastage pack for siebel documentation to me at (venky4u12@yahoo.co.in) Thanks and I appriciate ur help URS KR

What is the 45 value? Is this just an indicator that that row is a duplicate key and that the col3 value is greater? Is it indicating that the col3 value is the highest for that col1/col2 key pair? What if this was your input: col1 col2 col3 ------------------------------ 123 , 6/24/08 , 237 123 , 6...

Exactly as I posted earlier. Use stage variables for check for "changed" (Col1 and Col2) and "larger" (Col3) in data sorted by Col1, Col2 and Col3. Derive your output columns accordingly. ... Thanks Ray... Could you please explain me in detail, what i have to do to achive this??...

The fact that the problem is urgent for you means that you should contact your support provider. DSXchange is a volunteer group and answers when and if the members find the time and energy to do so. You posted this as a server job on Windows, so you do have the option of declaring your Excel sheet ...

Give us an example of what the output data should look like, given your input data example. ... Thanks Ray.. I have searched in the fourm but i did not find any answer to my problem.. any way i would like to explain my issuse more elaborately... My source data contains several records.. My job desi...

Thanks Ray.. I have searched in the fourm but i did not find any answer to my problem.. any way i would like to explain my issuse more elaborately... My source data contains several records.. My job design like ...One driving table, few look up table .. and i am writing to hashed file. Like this we ...

DS Guru's I had a problem in my job. I have three input columns like ID , date, seq my requirement is like i have to check id and date columns for dupilcate entries. if i have duplicate entries on id and date.. then i have to check seq.. and further i have to write "xx" to new column in ou...