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 steps for data modeling?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are the names of the layers in etl?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is session partitioning?
What are the etl testing operations includes?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is session partitioning?
When do we go for the tools in the market?
Do we need an ETL tool? When do we go for the tools in the market?
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.