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 a materialized view log?
What are materialized views & where do we use them?
Explain etl mapping sheets?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is etl process? How many steps etl contains?
Define slowly changing dimensions (SCD)?
can be used COM component in Informatica ?
what is the difference between cubes and package in cognos
What is grain of fact?
what is Forward,Reverse and Re_engineering?
what is different between sequential batch and concurrent batch and which is recommended and why?
What are the three tiers in etl?
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.
Compare ETL & Manual development?
how to connect to a flatfile through ftp in informatica