What is a mapping, session, worklet, workflow, mapplet?
What is a staging area? What is the purpose of a staging area?
what are the reporting tools and difference between them?
Explain what is etl process? How many steps etl contains explain with example?
explain the methodology of Data Warehousing?(Polaries)
how to load the data to fact table?
What is grain of fact?
How etl testing is different from database testing?
Identifying the bottlenecks in various components of Informatica and resolving them.
1)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 ?
What is a materialized view log?
What is virtual Data Warehousing?
Hi, Lookup() is what kind of join ?