how to find unique records in informatica level
What is critical column?
What is a Data Warehouse?
Explain which columns go to the fact table and which columns go the dimension table?
What is surrogate key? Where we use it? Explain with examples.
Explain what are the mapping paramaters and maping variables?
What is Conceptual, Logical and Physical model?
What is drilling across?
What is pre-emptive and non-pre-emptive?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is meant by metadata in context of a data warehouse and how it is important?
Whether dimension table can have numeric value?
What is the difference between dependent data warehouse and independent data warehouse?