I have a table that contains product attributes. Each product can have multiple attribute records associated with it. My export flat file has a column for each product attribute that I need to map each attribute record to. Is there a way to query for all the attributes for a given product and then transform them to the appropriate metadata fields? I was originally going to query for each attribute, but that could generate quite a bit of queries for each product record. Thoughts?
Thanks,
Andrew
Thanks,
Andrew
-
Hi Andrew
You could try to increase the 'Fetch size' property of the DBInputTable, so the amount of queries will decrease proportionally. Possibly the fastest way would be getting all of the attributes from the table and assign them to the product via denormalizer, which is capable of joining multiple records into one. But the concrete solution depends on the structure of your data. If you want me to help you find the best solution, please send me some sample of your input data and the graph.
Best regards
Please sign in to leave a comment.
Comments 1