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
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 |
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 |
What is the difference between project backlog and product backlog?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What do you understand by active and passive transformations?
where are the log files generally stored.Can you change the path of the file.what can the path be?
how do use session mapping parameters ?(in which transformation)
What are the new features of informatica 9 version?
Explain do we need an etl tool? When do we go for the tools in the market?
What are the types of Data Warehouse applications?
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain about hash partitioning?
What are materialized views & where do we use them?
What are the names of the layers in etl?