what are fact tables and dimension tables?
give example assuming one table.
Answer Posted / srikanth
Hi this is srikanth, A fact table consists of the
measurements, facts of a business process.
Dimension table consists descriptive or meaningful
information of business process.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are datastage sequences?
Why do we use exception activity in Datastage?
How a routine is called in datastage job?
What is difference between symmetric multiprocessing and massive parallel processing?
What is use Array size in datastage
Name the different types of Lookups in Datastage?
Notification Activity
What is difference between join, merge and lookup stage?
How many types of views are there in a datastage director?
What are iconv and oconv?
Differentiate between validated and Compiled in the Datastage?
Differentiate between datastage and informatica?
How to clean the datastage repository?
How to reverse the string using SQL?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name