Good afternoon DSXchangers,
Is it a red flag if I use 1 lookup stage to do multiple different lookups in terms of performance? I am essentially using one lookup stage instead of many lookup stages to do lookups against different tables.
The algorithm is simplified as below.
Stream ----Only LookUp Stage--Lookup Dates Dim Table -- Date Key
--Lookup One_Dim Table -- One Key
--Lookup Two_Dim Table --Two Key
I test with decent data volume and does not cause an issue data or performance wise so far.
Any input would be greatly appreciated.
Thank you!!
Multiple lookups in one Lookup Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Mon May 01, 2006 11:27 am
Re: Multiple lookups in one Lookup Stage
That makes absolutely no difference.Amuktamalyada wrote:I am essentially using one lookup stage instead of many lookup stages
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 19
- Joined: Mon May 01, 2006 11:27 am
Re: Multiple lookups in one Lookup Stage
Thanks Craig!!