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 do we call shell scripts from informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to create the source and target database connections in server manager?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the procedure for creating independent data marts from informatica 7.1?
Which transformation is needed while using the Cobol sources as source definitions?
what is the complex transformation you used in informatica
What is union transformation in informatica?
How to do the error handling of if ur source is flatfiles?
What is update strategy transform?
Define mapplet?
What is joiner transformation in informatica?
Explain sessions and how many types of sessions are there?
What are the main features of Oracle 8i with context to datawarehouse?