November 11, 2008 at 8:05 am
Hello.
I have 2 tables, Assets(id,name, etc), and Dependency(id,name)
I have the following file.
Codigo de sucursal;Nombre sucursal;Ciudad ;Equipo ;Placa Bancolombia ;Marca;Modelo ;Serie ;Tipo De servicio;ubicación activo;Capacidad;Fecha Compra;Fecha Garantia;Fecha Instalacion
6;AVENIDA JUNIN;Medellín;RECONTADORA;0054176;DE LA RUE;125 HS;1360/0009;RECONTADORA DE BILLETES;1 Piso;0;25/03/2008;14/04/2009;15/04/2008.
The second column is the name of the dependency, however I need to insert in the asset table the id, not the name, I guess I have to make a lookup, but I dont know how it works
thanks!!!
November 17, 2008 at 5:55 pm
The Lookup Transform will do two things: It will validate rows in your data flow against a given table, and will also (optionally) pick up additional values in the row matched in the lookup table. When you do your validation, pick up the additional value you need to add to your data flow.
To do this, make sure the column you want to include is in your lookup table query. Check the box beside that column in the "Columns" tab of the lookup. That checked value will then be available in your data flow.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply