When you have 2 servers in two different time zone and if
you need to extract data from 1 server and load it in
another server, how do you go about it? Best method to be
used.

Answers were Sorted based on User's Feedback



When you have 2 servers in two different time zone and if you need to extract data from 1 server a..

Answer / nagesh

using FTP we can achieve this

Is This Answer Correct ?    2 Yes 0 No

When you have 2 servers in two different time zone and if you need to extract data from 1 server a..

Answer / s

use Time stamp on the server. such that we can worked on
the time zone & set as per time & have data.

Is This Answer Correct ?    0 Yes 2 No

When you have 2 servers in two different time zone and if you need to extract data from 1 server a..

Answer / sahil chawla

For Extraction and Loading keep the time to GMT, after that
revert it back to original.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More ETL Interview Questions

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  


What is abap? What are idocs?

0 Answers  


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

0 Answers  


What is etl process. How many steps etl contains explain with example?

0 Answers  


how do use session mapping parameters ?(in which transformation)

0 Answers  






What is tracing level?

0 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  


CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 Answers  


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  


What is staging area referring to?

0 Answers  


What are the new features of informatica 9 version?

2 Answers  


how many steps are there in etl process?

0 Answers  


Categories