Un-Answered Questions { Data Warehouse }

What is different between the data warehouse and data mart?

630


What is the fact table?

595


What is data caches/ index caches?

619


What do you mean by blocking transformation?

591


What are batches?

623


How many dimensions are there in informatica?

634


Explain what transformation and how many are there in informatica?

494


What are the static cache and dynamic cache in informatica?

722


How to delete duplicate row using informatica?

617


How can you generate reports in informatica?

587


Can you generate sequence numbers without using the sequence generator transformation?

605


Is stop and abort are same in informatica?

574


Do you find any difficulty while working with flat files as source and target?

680


What is pmcmd command?

681


What is a surrogate key?

563