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
Updating Oracle_OCI_9
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 31
- Joined: Mon Dec 01, 2003 6:24 am
- Location: London