It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,108
×1,235

question asked: May 27 '13, 9:39 a.m.
question was seen: 4,412 times
last updated: Jun 03 '13, 5:19 a.m.

Related questions

CLM ETL jobs execution after upgrade to Insight

0
Ruslan Luchnikov (31●2●13●11) | asked May 27 '13, 9:39 a.m.
Hi, all
We upgraded RRDI v.2.0.1 to Insight 1.1.1. Insight to integrate with CLM 4.0.2.  After upgrade, ETL jobs execution became to slow. For example time of Java ETL execution 8-9 hours, ETL execution in Data Manager 20 hours.
Data warehouse database  Oracle 11.2.0.2. How can to optimize ETL jobs execution?

Thanks in advance.
Comments
Xuan Jiang commented May 27 '13, 9:46 a.m.

Ruslan - Can you provide the Java ETL log and/or the DM ETL log, as well as the JDBC log? BTW, how long before you upgrade?

2 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Ruslan Luchnikov (31●2●13●11) | answered Jun 03 '13, 2:26 a.m.
I found my mistake. I included in the job OOTBE2E - CLM4.0.1_All and jobs for RTC,RQM and RRC also. Now I'm left the job CLM_All, and time execution the DM ETL decreased.
0
permanent link
VK L (817●7●157●159) | answered Jun 03 '13, 5:19 a.m.
 Hi Ruslan,
                   You can configure delta loads to run everyday so that only the incremental changes are updated and will be minimal.
Initial run will require a full load

Thanks.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.