DSXchange

Hi Friends

I am newbie to DataStage, so please bear with me.
I have a question regarding OracleOCI9.
I am working on a job in which i got to insert or update a table based on different conditions.
When i am doing update i need to add 1 to the count field. I did it by using Hashed file and it works fine,but is there anyother way of doing it.
Its a huge table to be loaded in to Hashed file everyday.

Plz help me folks

thanks

Only put into the hashed file the rows necessary for processing on a given run. If your hashed file is coming from small table, just copy the table to the hashed file. But, if the table is huge, use meaningful information (probably from the source data being processing) to inner-join reduce the amount of rows copied to the hashed file for reference purposes.

You can use a user-defined update statement in your OCI Stage

Update <Table>
Set <CountField> = <CountField> + 1
Where ....