Stages

[samba]

I have two datasets

first dataset having the column names
1. JobName ----------- 2. JobNameresult
JobName ------- XXXXX


second dataset having the column names

1. Jobdesc ------- 2. Jobdescresult
Jobdesc ------- xxxxxxx


i have to load JobNameresult and JobdescResult into database

the database is having columns

1. JobName 2.Jobdesc 3.AAAA 4. BBBB
XXXXX xxxxxxx XXX XXXX



what is the best way to load into database


1. Dataset ------>

2. Datasset -----> what stage i need to use here ------>DATABASE


Thanks in advances

[gateleys]

What are the key columns in the two datasets that allows us to perform a lookup/join on the two?
You can use a simple lookup against a hashed file that is loaded with the lookup key and the JobDescResult columns. So, your design would be-

Code: Select all

                       JobDescHash
                          |
                          |
                          v
JobNameDataSet -------->Xfmr-------------->TargetDB

gateleys

[DSguru2B]

you mean lookup against a lookup set

[samba]

I dont have any key columns on two datasets

[samba]

here i have one column in first dataset
and one more column in second dataset
i dont have any other columns, i need to get two columns into one dataset or Database

[samba]

Can any one please help me

[DSguru2B]

you really need a key column to do the join on. Or how will you know what JobNameresult goes with what Jobdescresult.
WHere are these data sets coming from?
Are they being built from another table in the database or they have been built from some flat file?

[samba]

HI Thanks for the information

I Generated dummy key column to get the information


Thanks