Answer Posted / suren
Fact table contains measurement of information
Factless table contians with out any measure.
1.Additive : Additive fact table contains the summarized
data.
2.Non Additive : Non Additive fact table contains without
additve data.it contains only detail data
3.SemidAdditive: Semi additive fact table contains both the
summarized data as well as detial data
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define pmcmd command?
Quickly characterize reusable change?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the advantage of informatica?
Explain pmcmd command usage in informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Can you use flat files in Mapplets.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
In informatica workflow manager, how many repositories can be created?
pmscmd startworkflow -sv
Can we get 1st record through Informatica(without sequence number).
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the different clients of powercenter?
How to load the data from people soft hrm to people soft erm using informatica?