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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

1816


what is granularity in Data ware House?

1160


How to delete data which is not in source table?

825


what is an ETL or ETT? And what are the different types?

6912


explain the methodology of Data Warehousing?(Polaries)

1791






how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2043


What do you understand by active and passive transformations?

542


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2081


What are the different Lookup methods used in Informatica?

509


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2049


what are the reports developed in sap bw project and what is the requirement for developing it?

1767


what do u do when DB time takes more?in sap bi

1777


What is tracing level and what are the types?

526


What is abap? What are idocs?

505


What is etl tool in hadoop?

486