I am new to this and I am trying to figure out how to use a lookup component. In my reader I have a field called Fac

In my lookup table I have a field called facilityID, facility - I want to lookup facility and get the iD number to insert into my destination table. How do I do it?

David

Add an lookup _object_ to your transformation an _link_ it to source and target
Double click on lookup _object_ to change it properties
select lookup source data
and set all necessary connection details
First field in lookup source is always key and second is a value

for example

if you have a field with two possible values 1 and 0 and you would like to convert it to Yes and No

You lookup table or file will look like

Key Value
1 Yes
0 No

We can create a video for you if you wish

John

PS

I think would be beneficial for you to know that we are currently adding support for direct connection for MySql,Inter_base_ and PostgreSql data_base_s