Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 12913 Views
- I also Faced
- E-Mail Answers
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 |
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
without using ETL tool can u prepare a Data warehousing and maintaining?
what is the difference between OLTP database and data warehousing database?
How many steps etl contains explain with example?
flat filevalidation in informatica
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
Define slowly changing dimensions (SCD)?
how to load the data to fact table?
Difference between flat files and relational sources?
what is session partitioning?
What are the new features of informatica 9 version?
Teradata 
