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 meant by incremental load?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
what is session partitioning?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
if i have a query as flat file how can we load data to target table
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is the meant by Normalization and de-normalization?
What are materialized views & where do we use them?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is session partitioning?
what are the concerns of OLTP and DSS systems?
can cubes contain measures ?