0 votes
in Informatica by
Describe different methods to load dimension tables?

1 Answer

0 votes
by

Two different methods are there for loading data in dimension tables. They are as follows:

>> Direct or fast: In this method, all the keys and constraints are disabled prior to loading the data. Once the complete data is loaded, it is legalized against all the keys and constraints. In case the data is found to be invalid then it will not be included in the index. Plus, all the future processed on this data is skipped.

>> Conventional or slow:  In this method, all the keys and constraints are legalized prior to the data is loaded. In this way, it helps in maintaining data integrity.

Related questions

0 votes
asked Feb 26, 2023 in Informatica by rajeshsharma
0 votes
asked May 23, 2023 in Informatica by SakshiSharma
...