Explain the definition of normalized and denormalized view and what are the differences between them?
What is the difference between aggregate table and materialized view?
How to pivot row data using informatica?
Do you view contain data?
What is Snow Flake Schema design in database?
Explain multivalued dependency?
Explain how to export mappings to the production environment?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
Explain the main difference between inmon and kimball philosophies of data warehousing?
In datastage can ve find the job based on source table name ??
What is surrogate key? Where we use it explain with example?
Compare aggregates and data marts