Answer Posted / parthasarathi swain
A Dimension table is a table that contains detailed and
consistent data ie those data that are not frequently
changing in the other words we can say those as master data.
We use the primary key of the dimensional table as the
foreign key in the fact table. For one fact table we can
have more than one dimensional table.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to start a workflow using pmcmd command?
Can we create a Integration service without a Repository service and vice versa?
How to extract the informatica rejected data?
What are active transformations.
draw informatica architecture 8.6 ?
How to elaborate powercenter integration service?
What is sq transformation?
Explain pushdown optimization and types in informatica
Briefly define reusable transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is rank transformation in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain lookup transformation is active in informatica
What are roles and groups and benefits of using them?