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 13290list 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 7426what is different between sequential batch and concurrent batch and which is recommended and why?
4964A 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?
22681)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 ?
2163Informatica 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?
3816
What are the etl testing operations includes?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what happens if the info.server doesn't find the session parameter in the parameter file?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Explain about round-robi?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the three tiers in etl?
What is tracing level?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Explain what is etl process? How many steps etl contains explain with example?
Is hadoop a etl tool?
What is lookup table in etl testing?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
how does the server recongnise the source and target databases.Elaborate on this
dimension object created in oracle can be imported in designer?how?