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

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

1804


Explain do we need an etl tool?

525


explain the methodology of Data Warehousing?(Polaries)

1796


what make u disappointmnets in u r career

1780


how do u identify the changed records in operational data?

2135






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

1541


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

1629


what is Forward,Reverse and Re_engineering?

1726


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3316


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?

1825


what are the concerns of OLTP and DSS systems?

1969


what is data modeling?

1466


Is apache nifi an etl tool?

547


Explain about hash partitioning?

540


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1654