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.
- 3 Answers
- 11933 Views
- I also Faced
- E-Mail Answers
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 are the key benefits of ETL Testing?
Explain about enterprise scalability and roi of data integration suite?
What are the three tiers in etl?
what are the facilities provided by data warehouse to analytical users?
What is Relational Integrity?
Two default user groups created in the repository are____and_____.
Do we need an etl tool?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is different between sequential batch and concurrent batch and which is recommended and why?
what are the types in error loging?
What is grain of fact?
Teradata 
