Metadata is data about data. E.g. if in data mart we are receiving any file. Then metadata will contain information like how many columns, file is fix width/limited, ordering of fields, data types of field etc.
Data warehouse is made up of many datamarts. DWH contain many subject areas. However, data mart focuses on one subject area generally. E.g. If there will be DHW of bank then there can be one data mart for accounts, one for Loans etc. This is high-level definitions.
Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables. In data, wares housing mainly the people are using the conceptual hierarchy.
Informatica filter transformation default value is 1 i.e. true. If you place a break point on filter transformation and run the mapping in a debugger mode, you will find these values 1 or 0 for each row passing through filter. If you change 0 to 1, the particular row will be passed to next stage.
Select appropriate Question to view its more answers in this category of
Do you find any Answer incorrect or incomplete? Please e-mail us or
place your comment and mention the number of question or if you have correct answer then
open the appropriate question by clicking on question and then place your answer in comment
regarding particular question in this category "Data Warehousing Interview Questions and Answers" To ensure quality,
each change is checked by our team, before it enters the main website
database. If you desire so, the changes will be credited to your name.
Subscribe your email to receive free updates:
Enter your email address and get free web tutorials, job hunting tips, career advices, job vacancies and interview questions updates directly delivered to your email inbox