This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Jobs Discussion and the fly likes Interview Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Careers » Jobs Discussion
Bookmark "Interview" Watch "Interview" New topic
Author

Interview

sudha javvadi
Ranch Hand

Joined: Mar 23, 2007
Posts: 97
Hi all,

I am having an interview on Monday. They are looking for a Java developer with strong database knowledge. They are having a huge data migration project. I have never done any data migration. What type of questions I may be asked? Can anybody tell some example of data migration using java and oracle. So that I can be prepared for this interview with some examples. I did some google search but it all about pure data migration using some data migration tools. It didn't helped that much.

Thanks in advance,
Sudha.
Henry Wong
author
Sheriff

Joined: Sep 28, 2004
Posts: 18497
    
  40



Well, I would assume "strong database knowledge" to mean knowledge of the SQL language.

Henry


Books: Java Threads, 3rd Edition, Jini in a Nutshell, and Java Gems (contributor)
sudha javvadi
Ranch Hand

Joined: Mar 23, 2007
Posts: 97
Thank you for your reply Henry. Can you tell me how to migrate data from one server to another from a developer point of view.

Regards,
Sudha.
Henry Wong
author
Sheriff

Joined: Sep 28, 2004
Posts: 18497
    
  40

sudha javvadi wrote:Thank you for your reply Henry. Can you tell me how to migrate data from one server to another from a developer point of view.

Regards,
Sudha.


Data migration depends on where the source is, where the target will be, what the original format is, what the target format will be, etc.... There is no magic migrate command that will work for everything. You need to fluent in Java, SQL, and the tools that will be used.

Henry
arulk pillai
Author
Ranch Hand

Joined: May 31, 2007
Posts: 3219
XML and related technologies like XSLT, XPath, XQuery etc are also very useful for data migration. You can export the data from application A as A.XML and then use XSLT & XPath to translate that to B.xml understodd by application B.

Some applications provide facilities to export in an archive format e.g. A.jar or A.zip and then import into the other application.

It is bit hard to say without having more details.


Java Interview Questions and Answers Blog | Amazon.com profile | Java Interview Books
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Interview
 
Similar Threads
[Some company] interview suggetion
How to prevent "lack experience in corporate setting"?
Data Structure in Java
Data Migration
Opportunities Australia