Answer Posted / shyam shah
A dimension table is a table in a star or snowflake schema
that stores attributes that describe aspects of a dimension.
For example, a time table stores the various aspects of time
such as year, quarter, month, and day. A foreign key of a
fact table references the primary key in a dimension table
in a many-to-one relationship.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
Mention a few design and development best practices for informatica?
can we override a native sql query within informatica? Where do we do it?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is rank transformation?
Explain lookup transformation is active in informatica
What is confirmed fact in dataware housing?
How big was your fact table
What is a filter transformation?
How identifying bottlenecks in various components of informatica and resolving them?
Explain the scenario which compels informatica server to reject files?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain why we use partitioning the session in informatica?
Explain the tuning lookup transformation - informatica
Why sorter is an active transformation?