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

Can there be sub steps of etl steps?

693


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

1944


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1870


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.

1936


Explain about etl data integration software?

647


What is partitioning? Explain about round-robin, hash partitioning.

719


Explain the use lookup tables and Aggregate tables?

711


what is the difference steps for data modeling?

1768


List few etl bugs?

700


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

1943


What is tracing level and what are the types?

693


what is the use of server manager?

1795


What is tracing level?

827


What is cube grouping?

741


hoe to access second value in mapping parameter if it is having more than one value ?????????????

1311