how to find unique records in informatica level
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is freehand sql?
Explain what are necessary tasks to install reportnet software?
What is the difference between dependent data warehouse and independent data warehouse?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is many-to-many dimensional model in datawarehousing ?
What is a real-time data warehouse?
How do we design a universe?
Explain what is the difference between view filter and report filter?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Code the tables statement for a single-level (most common) frequency?
What are situations where snowflake schema is better than star schema when the opposite is true?