Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

join two table ?

Status
Not open for further replies.
donny750

donny750

Programmer
Jul 13, 2006
145
0
0
FR
hello,

sombody can explain me how to join to table with a lookup ?
and why use a lookup and not a SQ or joiner ?

thanks
 
Sort by date Sort by votes
You can use a lookup anywhere within a mapping, whereas you need a SQ to fetch data from a database at the start of a mapping. A joiner is strictly an object that works within the ETL engine (for joining data that is already fetched)


Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Router Output to a "Single Target Table"
Replies
1
Views
51
rasETL
rasETL
sa0309
  • Locked
  • Question
Informatica Target Table update 1
Replies
2
Views
50
sa0309
sa0309
robz2009
  • Locked
  • Question
Sybase (SQL Advantage) Join syntax
Replies
2
Views
38
robz2009
robz2009
rodneyc8063
  • Locked
  • Question
Informatica Query Tables for Workflow Schedules (SCHEDULER, WORKFLOWS)
Replies
1
Views
60
blom0344
blom0344
newestAF
  • Locked
  • Question
2 Table Query matching similar fields
Replies
3
Views
33
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top