Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / m.sivakumar
The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is SDLC way of code development?
What is data transformation manager process?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is union transformation in informatica?
design of staging area?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is InformaticaPowerCenter?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to join three sources using joiner? Explain though mapping flow.
How union transformation is used?
Design a mapping to load a target table with the following values from the above source?
What is standalone command task?
Did u used latest transformations of 8.6.0? for what?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is informatica metadata?
