Hi,
I’ve searched the forum but didn’t see anything with this very basic problem, so I suspect it is something I am missing from the user guide.
I am having trouble with DB Lookups. I’ve defined a DB lookup a few different ways:
- query like: select * from dim
- query like: select name, id from dim
- no metadata
- metadata with name, id
I’m unable to reference this lookup. In my reformat, I do:
lookup(LookupTable0, $0.name).id
When I run the graph, I get the following error:
Interpreter runtime exception on line 20 column 51 : java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). with field ‘_field0’ when mapping…
In other tools, I have to specify a key, but I didn’t see where I specified this.
What am I doing wrong?
*** One gripe I have about lookups is that I don’t see a way to change the ID, which is what is used in all the references to it. I don’t understand why we don’t just use the logical names to reference the lookups, like Ab Initio.