Answer Posted / m.sivakumar
The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can we override a native sql query within informatica?
How can you generate reports in informatica?
What is a stored procedure transformation?
What are the static cache and dynamic cache in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What do you understand by a term domain?
r u done any partitions in ur project?
explan ur project architecture?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is workflow? What are the components of the workflow manager?
What are the different clients of powercenter?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the use of code page?
How to open an older version of an object in the workspace?
How can we use mapping variables in informatica? Where do we use them?