How can I lookup the values in Mongodb? I use stream lookup but i think it will have a performance issue when looking up on a collection with high volume of data.
标签:
pentaho-spoon
相关问题
- Error connecting to database: (using class org.gjt
- The system cannot find the path specified (Batch f
- Pentaho DI - JSON Nested File Output
- Running pentaho spoon UI in intellij
- Break string into columns using Regular Expression
相关文章
- The system cannot find the path specified (Batch f
- Pentaho DI - JSON Nested File Output
- Running pentaho spoon UI in intellij
- Break string into columns using Regular Expression
- Fetching the max value from ROWS in pentaho
- How to run different sql to get data according to
- (stderr) =256m“”==“” was unexpected at this time i
- How to validate one csv data compare with another
Solution 1:
Found this on the market place "mongodblookup" There is only one problem with the plug in, it doesn't return a record if the lookpup match fail.
Solution 2:
UJDC - 2 field from input stream - artist_id,translation (this is the identifier for the lookup)
jsonColl - is a field in UJDC it will return null if no document found.
Below is the code