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
- 13003 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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?
Explain about etl data integration software?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is a materialized view log?
what is granularity in Data ware House?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Is hadoop a etl tool?
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.?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Explain and compare etl & manual development?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
what are the concerns of OLTP and DSS systems?
what is different between sequential batch and concurrent batch and which is recommended and why?
What is data modeling and data mining?
