How can you define a transformation? What are different types of transformations in Informatica?
TCS,
7 8865Post New Data Warehouse General Questions
What are data modeling and data mining? Where it will be used?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is conformed fact?
What are the reasons to use a chameleon method in data warehousing?
How to get the first 100 rows from the flat file into the target?
What is surrogate key? Where we use it? Explain with examples.
For faster process, what we will do with the universe?
Explain what are the advantages data mining over traditional approaches?
Why is business intelligence (bi) important in data warehousing?
What are the different models used in cluster analysis?
Explain differences between star and snowflake schemas?
Explain what is a three tier data warehouse?
Start a batches with in a batch?
Explain the data type of the surrogate key?
Why we use repository connectivity?