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 11742list 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 6387what is different between sequential batch and concurrent batch and which is recommended and why?
4570A 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?
19371)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 ?
1784Informatica 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?
3427
What is tracing level?
State the differences between shortcut and reusable transformation
Explain about etl data integration software?
what are the facilities provided by data warehouse to analytical users?
how do use session mapping parameters ?(in which transformation)
What is partitioning? Explain different types of partitioning?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is the use of server?
Which transformation we use to convert 'NA' to 'Not Available'
how does the server recongnise the source and target databases.Elaborate on this
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?
What do you understand by active and passive transformations?
how do u extract data from different data sources explain with an example?
how many steps are there in etl process?
Explain about the data integration suite features?