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
Stages
Moderators: chulett, rschirm, roy
Re: Stages
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-
gateleys
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
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?
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?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.