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
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
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?
What is the difference between Data Warehousing and Data Mining?
What are the key benefits of ETL Testing?
what is the meaning of upgradation of Repository?
how does the server recongnise the source and target databases.Elaborate on this
what is the difference between cardinality and Nullability?
How to fine tune mappings?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is etl process? How many steps etl contains?
What is staging area referring to?
can cubes contain measures ?
What is meant by incremental load?
What is a staging area? What is the purpose of a staging area?