How can you define a transformation? What are different types of transformations in Informatica?
TCS,
7 8774Post New Data Warehouse General Questions
What is VLDB?
What is the very basic difference between data warehouse and operational databases?
How to define a cube??
Explain what is the difference between datawarehouse and bi?
What needs to be done when the database is shutdown?
What are the stages that are required in data warehousing?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
How can we run the graph? How can we schedule the graph in unix?
What is a full backup?
What are components of report studio?
Explain what is the extension of file to save template?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is surrogate key? Explain with examples.
What is vldb(very large databases)?