• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SCEA Books

 
Shruti Sharma
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Can anyone suggest really good books and training material to prepare for SCEA?

 
Amritendu De
author
Ranch Hand
Posts: 188
11
Java Oracle
 
Shruti Sharma
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you so much for your response! ARe there 3parts to this exam in the following sequence:

1Z0-864
1Z0-866
1Z0-865

How long will it take to prepare for all the exams?

 
Amritendu De
author
Ranch Hand
Posts: 188
11
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can get the latest certification requirements from Oracle site. That way you can get the updated and latest information.
 
Shruti Sharma
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you so much! I have another question on enhancing the batch performance:

My batch job is supposed to process 500,000 records. Currently, it crashes after 70,000 records. Here are the steps we are performing:

1. Read the records from the file and dump into the Staging (temporary) table (this step takes just about few seconds since we are using DB2 loader).

2. Read the data from the staging table and populate the main application tables. This is where the batch code is giving performance issues. Any tips to enhance the performance?

Any inputs would be greatly appreciated.
 
Amritendu De
author
Ranch Hand
Posts: 188
11
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use Divide and Conquer strategy by implementing multi-threading techniques.
 
Vijayendra Bhati
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shruti Sharma wrote:Thank you so much! I have another question on enhancing the batch performance:

My batch job is supposed to process 500,000 records. Currently, it crashes after 70,000 records. Here are the steps we are performing:

1. Read the records from the file and dump into the Staging (temporary) table (this step takes just about few seconds since we are using DB2 loader).

2. Read the data from the staging table and populate the main application tables. This is where the batch code is giving performance issues. Any tips to enhance the performance?

Any inputs would be greatly appreciated.


We are also using the same approach but this seems to be working fine with us.We are pre processing our file before dumping data in staging table.Along with it we are also doing some processing while transferring data from staging to main table using some stored proc.

But I guess better approach could be using Spring Batch.Try to explore it too.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic