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 11918list 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 6526what is different between sequential batch and concurrent batch and which is recommended and why?
4633A 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?
20021)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 ?
1848Informatica 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?
3484
Explain about enterprise scalability and roi of data integration suite?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
When do we go for the tools in the market?
SCD2 will work on only dimension tables as well as fact Table?
what is Forward,Reverse and Re_engineering?
What are the differences between sql override and update override?
how does the server recongnise the source and target databases.Elaborate on this
can be used COM component in Informatica ?
what is the use of structures?how many nodes can u create in a structure?
what are the production issues in datastage?
what is the difference steps for data modeling?
Identifying the bottlenecks in various components of Informatica and resolving them.
how do u set partition points in the mapping?
What is tracing level?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
