Using an Oracle table as a lookup

johnno · Post by **johnno** » Thu Sep 25, 2003 9:47 am

Hi all,

Using V6 on W2K. I want to use an Oracle table as a lookup to validate some data against, but it keeps asking for a table name. When I set this up using the ORAOCI9 stage, there is no where to enter a table name. Does this mean that the table name is set in the driver and that a new driver needs to be set up for each table you wish to access?

As usual, any help greatly appreciated.

tonystark622 · Post by **tonystark622** » Thu Sep 25, 2003 10:34 am

Hi Johnno,

If you set the query type to "column generated", then click on the build button, you'll see the "From clause" text box. You can put the table name in there. Then change your query type back to what it was. You may want to copy the SQL before you do this, if you're using User-Defined SQL.

Good Luck,
Tony

chulett · Post by **chulett** » Thu Sep 25, 2003 10:34 am

It's there, just not in the most obvious place. It depends on your "Query Type".

*Fully Generated SQL Query. Click 'Build' and work thru the stupid [}:)][;)] query builder. Pick the table name(s), columns, etc from your imported metadata.
*Column Generated SQL Query. Click 'Build' and you'll something more intuitive to fill out - From, Where and Other clauses.
*User Defined SQL Query. All up to you.

-craig

ray.wurlod · Post by **ray.wurlod** » Thu Sep 25, 2003 4:31 pm

Or choose the Grid Style GUI [:D]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

chulett · Post by **chulett** » Fri Sep 26, 2003 6:02 am

Oh yah - right-click and select the Original Recipe 'Grid Style'. Why is that the only way to 'inject' connection Parameters into the OCI stage? Who types in parameter names when you can click an 'Insert Parameter' button? [:D]