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 12974list 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 7170what is different between sequential batch and concurrent batch and which is recommended and why?
4879A 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?
21821)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 ?
2068Informatica 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?
3726
How many steps etl contains explain with example?
When do we analyze the tables?
What is abap? What are idocs?
What is the difference between round-robin partitioning and hash partitioning?
What are your responsibilities as an etl tester?
what is the meant by Normalization and de-normalization?
A 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?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are the different Lookup methods used in Informatica?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How to fine tune mappings?
What do you understand by active and passive transformations?
how do u identify the changed records in operational data?
Do we need an ETL tool? When do we go for the tools in the market?