DSXchange

Could you be more elaborative of this method as I wanted to implement at my work place.Where do I find ETLSTATS...

Thanks

VG

Hey Folks, I want to notify the production support team whenever a job is failed with an e-mail notification containing the error log(as attachement) or the direct log of the job ,so that the person need not login to DS director to look at the error.Any suggestions will be greatly appreciated. Thank...

I thank you all for your suggestions.Since the job being already developed some one, I have no clue of its design.But I found that the table is getting truncated before the data is being loaded in to it and this action was mentioned at the source stage in the before tab.I apolozise for your valuable...

How can I check if there are any triggers which are deleting.Im not aware!!!

Im connecting to MSSQL server thru DRS stage.

Yes,

I have seen the before and after tabs and there are no expressions in them

Looks wierd!!!

Thanks D.S Guru!!! Yes, I can get rid of that message. Here is the situation.The target table is loaded from two different sources 1 and 2 with insert and update action in the same job.Source 1 is empty. Source1--->Target Source2--->Target When I run the job, I observed that there is no record of hi...

Hi Ppl, Im performing an insert and update to a table from a source table.Ever time when I run the Job, the job is not performing any insert and update,but instead it is performing truncating the table and inserting the data.When I viewed the log,I got the following message. This update action 'inse...

Hi D.S Gurus, Below is the job structure,Im performing.In this Job, the data is loaded in to a table X.Using that table as source, I'm making a lookup with the help of a hashed file(part of the data from table X is sent to this hashed file for look up) in the transformer 2. In transformer 2, I make ...

Hi DS Gurus, I'm doing the following job. Hased File---->Transformer---->RowSplitter---->Transformer---->DRS database. The job runs perfectly,but when the view the data in the target table, I observed that one column in the middle is left empty and all the columns have been shifted to subequent colu...

GATELEYS,
Amazing....Thanks a lot... U logic really helped me a lot.
This Forum is great for beginers like me....
Keep up your good work.
Regards,
Vish. :D

Yes,This was the job design I planned to implement,as I'm new to D.S, Im not sure how can I implement the logic.I mean looping and stuff.

Thanks a lot for all Gurus for their valuable suggestions.

Cheers,
Vish :D

Does it matters when you return to a thread? Dont u think there is a better way of getting to the solution.

Hey

You can use the CRC32 function as u job logic to get rid of timestamp for your incremental loading.

Bye,

Vish.

Hi D.S Gurus: I'm new to Datastage.I need your suggestions for implementing the logic. Here is the situation X is the source Y is the target Z is a target in a warehouse Today the job was run X->Y-->Z Tommorow, certain rows from X are deleted I need to update those records in Z which are deleted in ...