-
which transformation useful for joining the multi table..........
i am retrieving the multi structures from source i want to define single target table structure for this which transformation i need to follow
-
fact less fact table
what is the fact less fact table? why we use this table?give me one example
-
Master detailed relationship
Can you apply the Master detailed relationship between Query studio report and report studio report? how?
-
Informatica Mapping level Questions
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
-
-
-
-
-
Repository deletion
what happens when a repository is deleted?If it is deleted for some time and if we want to delete it permanently?where is stored (address of the file)
-
-
-
-
-
What are Data Marts
Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse.