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 11783list 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 6409what is different between sequential batch and concurrent batch and which is recommended and why?
4576A 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?
19471)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 ?
1796Informatica 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?
3440
how do u handle performance issues in Informatica . where can u monitor the performance ?
What is a mapping?
how would u estimate the size of Aggregator transform data and index cache?
Explain do we need an etl tool? When do we go for the tools in the market?
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.?
Difference between flat files and relational sources?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are the types of Data Warehouse applications?
What is grain of fact?
if i have a query as flat file how can we load data to target table
What are three tier systems in etl?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is session partitioning?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
