Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sudheer kumar
A dimension table is table Which contains detailed
Information of Particular Unit, Dimension table contains
primary key which represents uniqueness of that table,
A foreign key of fact table References primary key of a
dimension table in many to one relationship.
Example:
Consider Time Dimension, it Contains detaild time
information like,
YYMMDD,YYMM,YYYY,YYQQ,YYWK.(Year,quarter,Month,Daate).
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Differentiate between Load Manager and DTM?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What can we do to improve the performance of informatica aggregator transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Define joiner transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How can we use mapping variables in informatica? Where do we use them?
What is resilience time?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Why is sorter an active transformation?
What is persistent lookup cache?
Where can we find the throughput option in informatica?
