|
Home > Archive > MS SQL Data Warehousing > February 2006 > topic on lookup transformation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
topic on lookup transformation
|
|
| srinivas 2006-01-23, 3:23 am |
| hi,
this is srinu.
my questions r 1) what is lookup transformation and in which situation
we use ?
2) what is difference between static and
dynamic?
i am awating for your earlier rely.
bye,
srinu
| |
|
| the lookup transformation simply do lookup against a database to retrieve a
value from this a table.
The usage is simple. for example:
when you have a table which contains a productID column and you want to
retrieve your datawarehouse surrogate key, you can use the lookup
transformation to retrieve this column.
"srinivas" <koritaladw@yahoo.com> wrote in message
news:1138003570.603178.289740@g44g2000cwa.googlegroups.com...
> hi,
> this is srinu.
> my questions r 1) what is lookup transformation and in which situation
> we use ?
> 2) what is difference between static and
> dynamic?
>
> i am awating for your earlier rely.
>
> bye,
> srinu
>
|
|
|
|
|