Different methods of loading Dimension tables
Describe briefly the different methods of loading Dimension tables?
Expert
The methods to load Dimension tables are illustrated below:
i) Conventional load :- in this the data is determined for any table constraints ere loading.
ii) Direct or Faster load :- The data is straightly loaded with no checking for any constraints.
What are the types of prompt?
Briefly describe the differentiation between star and snowflake schemas?
What does web mining mean
Write down a short note on the Volatile Temporary tables (VTT).
Write down the differentiation between lookup and filter transformation?
Describe the term Java bean?
Specify the ways in which we can create the port?
Write a short note on the difference between the disjoint and overlap rule.
Differentiate between Multiload and Fastload in terms of Performance?
How can we do unit testing into the informatica? How to load data in the informatica?
18,76,764
1939183 Asked
3,689
Active Tutors
1453797
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!