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 11141list 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 6066what is different between sequential batch and concurrent batch and which is recommended and why?
4436A 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?
18061)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 ?
1647Informatica 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?
3292
What is tracing level and what are the types?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Can we create Hierarchies in generic datasources?
What is etl process?
can be used COM component in Informatica ?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What are the modules in Power Mart?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the key benefits of ETL Testing?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Compare ETL & Manual development?
What is tracing level?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Can u access a repository created in previous version of Informatica?
State the differences between shortcut and reusable transformation