How to implement join
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Fri Jul 12, 2013 7:32 am
How to implement join
Hi Craig,
I have gone through the answers from forums other questions for this topic but yet I am not sure ...
I want to join a sql server table and text file on the basis of Varchar column and then two sqo server tables
But as the join stage is not supported in Server edition I am not able to figure
how this join can be achieved
Two sql server tables I can join in the ODBC stage..
But how to join a text file with Sql server table by matching their varchar column?
Thanks in Advance!
I have gone through the answers from forums other questions for this topic but yet I am not sure ...
I want to join a sql server table and text file on the basis of Varchar column and then two sqo server tables
But as the join stage is not supported in Server edition I am not able to figure
how this join can be achieved
Two sql server tables I can join in the ODBC stage..
But how to join a text file with Sql server table by matching their varchar column?
Thanks in Advance!
Rajendra
ETL Developer
InfoCepts
ETL Developer
InfoCepts
-
- Participant
- Posts: 22
- Joined: Fri Jul 12, 2013 7:32 am
Either import the file into your database and join them there or export the table to a file and use the Merge stage. From what I recall,those are your two primary choices in a Server job.
Depending on the type of kind of join, you may be able to put the file into a hashed file and use a lookup to perform the join.
Depending on the type of kind of join, you may be able to put the file into a hashed file and use a lookup to perform the join.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 22
- Joined: Fri Jul 12, 2013 7:32 am
Thanks Chulett and Ray
I am not clear with the concept of Hash files And as Server jobs dont have a Look up Stage how can we perform look up on hash files?
I dont have any idea of implementing the Hash files
The more am reading on it more getting confused
Please guide me on this...
I am not clear with the concept of Hash files And as Server jobs dont have a Look up Stage how can we perform look up on hash files?
I dont have any idea of implementing the Hash files
The more am reading on it more getting confused
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Please guide me on this...
Rajendra
ETL Developer
InfoCepts
ETL Developer
InfoCepts
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In server jobs lookups are performed with the Transformer stage.
The server Transformer stage takes one stream input and zero or more reference inputs (these are painted with short dashed lines). Reference inputs provide the lookup functionality.
Hashed files (note, not "hash" files) are implemented using Hashed File stage. You can get by using the defaults in this stage.
The server Transformer stage takes one stream input and zero or more reference inputs (these are painted with short dashed lines). Reference inputs provide the lookup functionality.
Hashed files (note, not "hash" files) are implemented using Hashed File stage. You can get by using the defaults in this stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 22
- Joined: Fri Jul 12, 2013 7:32 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: