Database as lookup

ravij · Post by **ravij** » Mon Jun 05, 2006 6:40 am

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

chulett · Post by **chulett** » Mon Jun 05, 2006 6:42 am

No. How do you propose to do a lookup without 'key columns'?

rwierdsm · Post by **rwierdsm** » Mon Jun 05, 2006 6:48 am

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

ravij · Post by **ravij** » Mon Jun 05, 2006 6:49 am

Hi Chulett,

thnaks for quick response.

Can u elaborate it a bit more please?

thanks in advance

rwierdsm · Post by **rwierdsm** » Mon Jun 05, 2006 6:55 am

chulett wrote:And the men who hold high places must be the ones to start
To mould a new reality closer to the heart...

You can be the captain, and I will draw the chart,
Sailing into destiny, closer to the heart.

Cool.

chulett · Post by **chulett** » Mon Jun 05, 2006 7:04 am

rwierdsm wrote:You can be the captain, and I will draw the chart, sailing into destiny, closer to the heart.

Been stuck in my head for something like the last week and I hoped this might exorcise that particular demon. Nope.

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?

DSXchange