1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

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.

Question Posted / dev

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

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,

how many maximum session supports to multiload in teradata ??

0 Answers   IBM,

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,




what are the facilities provided by OLAP to analytical users?

1 Answers  

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  

What is etl tool in hadoop?

0 Answers  

What is a lookup table in etl?

0 Answers  

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

what is Forward,Reverse and Re_engineering?

0 Answers  

For more ETL Interview Questions Click Here
Categories