Hi
We need to perform a cursor lookup in order to find more than one row in the reference link
Our job design is a source from oracle table from one DB and another oracle table in the reference link.
Any ideas?
cursor lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Doh!! Me and my PX !!
In server, depending on volume, you can
1.) Use ODBC link
2.) Create db link
3.) Use hash file with combined rows
4.) Simulate multiple rows from rows so each with gather one reference row.
There are other methods also. Need more information on what you are attempting, volume, match possibility etc.
In server, depending on volume, you can
1.) Use ODBC link
2.) Create db link
3.) Use hash file with combined rows
4.) Simulate multiple rows from rows so each with gather one reference row.
There are other methods also. Need more information on what you are attempting, volume, match possibility etc.
-
- Premium Member
- Posts: 87
- Joined: Sat Jul 14, 2007 2:24 pm
That would be where the UV stage comes in. You can use one to access a hashed file as long as the hashed file was created in an account or you manually create a VOC record for it.
After that, it's a matter of creating the hashed files with enough keys to ensure all records get loaded and then using fewer keys to do the reference lookup in the UV stage so that there are multiples to return per 'key'. In either case you need to enable the option on the Link Properties page of the reference lookup.
The technique has been discussed here quite a bit.
After that, it's a matter of creating the hashed files with enough keys to ensure all records get loaded and then using fewer keys to do the reference lookup in the UV stage so that there are multiples to return per 'key'. In either case you need to enable the option on the Link Properties page of the reference lookup.
The technique has been discussed here quite a bit.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers