Hi,
I need to use the database as lookup n my sourse is also database, I need to map these two without a key column in XFM stage. How should i procede for this? Is there is any stage to use with out key col?
thanks in advance
Database as lookup
Moderators: chulett, rschirm, roy
Database as lookup
Ravi
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Re: Database as lookup
Ravi,
Are you using data pulled in the first DB read as values to 'lookup' in the second DB stage?
If so, you would define the values you want to lookup as keys in your second DB query, they would become part of the where clause.
If you are trying to do something else, please provide some more detail.
Rob Wierdsma
Are you using data pulled in the first DB read as values to 'lookup' in the second DB stage?
If so, you would define the values you want to lookup as keys in your second DB query, they would become part of the where clause.
If you are trying to do something else, please provide some more detail.
Rob Wierdsma
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com
Database as lookup
Hi Chulett,
thnaks for quick response.
Can u elaborate it a bit more please?
thanks in advance
thnaks for quick response.
Can u elaborate it a bit more please?
thanks in advance
Ravi
Been stuck in my head for something like the last week and I hoped this might exorcise that particular demon. Nope.rwierdsm wrote:You can be the captain, and I will draw the chart, sailing into destiny, closer to the heart.
![Laughing :lol:](./images/smilies/icon_lol.gif)
Ravi, keys provide values for the 'where' clause which is why there really isn't any such thing as a lookup without key columns. Read Rob's reply. Post more details of what you are actually trying to accomplish rather than telling us how you think you 'need' to do it.
Perhaps you should just join the two data sets in the source query?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers