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 12922list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
2 7139what is different between sequential batch and concurrent batch and which is recommended and why?
4860A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
21751)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
2061Informatica 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?
3717
what is the use of server?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What is lookup table in etl testing?
What is etl process? How many steps etl contains?
What is etl process. How many steps etl contains explain with example?
What are your responsibilities as an etl tester?
what are Lookup caches options? Including persistent caches.
how many maximum session supports to multiload in teradata ??
Explain different types of partitioning?
Which transformation we use to convert 'NA' to 'Not Available'
What is the difference between round-robin partitioning and hash partitioning?
what is session partitioning?
what are the facilities provided by data warehouse to analytical users?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain the difference between etl tool and olap tools?