Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Lookup doesn't work correctly
Currently I have a big problem problem using the ETL Server when I try to use the transformer "Lookup" in order to get the names of the german federal states out of the postal code. The postal codes are stored in a MySQL database und the Lookup file is an UTF-8 encoded CVS file.
Everythings looks very well and the job run successfully and fills a new dimension this way. But: not every postal code is replaced by the name of its federal state although the mapping is available in the CSV file. Why does this happen? May it be because the CSV file containing the mapping is too huge (76111 records)?
I can't find any error, so please tell me if you need some code (and which parts of course).
Best regards
RE: Lookup doesn't work correctly
Try to reduce your example: Only one postal code for which mapping doesn't work and in the Lookup-File only this entry. Then you can exclude the data size as reason. "Loopup"-Transformer should handle this correctly.
Take also a look at the sample importBiker for this transformer.
