DW vs LQE for JRS
CLM 606
All,
I was always told that you switch to LQE when you convert to Global Configuration. Well, we have not and are now hosted on an instance that has DW and LQE. We continue to use the DW for most reports, but @ an IBM conference, I remember someone saying that you could use LQE and get decent reports with Rich Text fields...or something like that....
Without GC turned on, what would be any benefit of using LQE as a source?
thanks
Accepted answer
Hi Mahari,
I could have worded that summary better. I was trying to summarize a couple of different advantages described in the post.
LQE doesn't have a pre-built schema, it is based on your data model. There have been instances where we've added new OOTB attributes in ELM that are only contributed to LQE, not the DW. As you noted in your original post, there are a few larger text fields that are only available in LQE.
Updating the DW with changes to your data model or attributes is dependent on when you run your DCC jobs, and there can be dependencies between ODS and datamart jobs. Updates to LQE are more automatic.
So really - it's about the data you need, the frequency of updates, and also what your infrastructure provides (there are of course sizing and performance considerations if you decide to stand up LQE in addition to the DW).
Hope that helps.