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
What is etl tool in hadoop?
What is fact? What are the types of facts?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Explain about hash partitioning?
what is the difference between cardinality and Nullability?
what are the reports developed in sap bw project and what is the requirement for developing it?
what is an ETL or ETT? And what are the different types?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what is the difference steps for data modeling?
how do u identify the changed records in operational data?
Explain about power designer data modeling software?
what are the concerns of OLTP and DSS systems?
What is partitioning? Explain about round-robin, hash partitioning.
Explain about round-robi?
What are the modules in Power Mart?