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 / 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
Explain the use lookup tables and Aggregate tables?
how would u estimate the size of Aggregator transform data and index cache?
What are various etl 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.
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
What is data cleaning?
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.?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Two default user groups created in the repository are____and_____.
Explain about round-robi?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
tell me few points when u become TL
Can u access a repository created in previous version of Informatica?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What are the etl testing operations includes?