Answer Posted / rekha
Fact table is the primary table in the dimensional
modeling . the numerical performance of measures of the
business stored in fact table
mostly used facts ara numeric and additive
not every numeric is a fact ,but a numeric wich ara of type
key performance indicator is called fact
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
define galaxy repository in informatica
How to configure mapping in informatica?
What do you understand by SOA of Informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is SDLC way of code development?
Is it possible to create multiple domains on a single Informatica server?
What differs when we choose the sorted input for 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.
Explain the different lookup methods used in informatica?
What are the tasks that source qualifier perform?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain about Informatica server process that how it works relates to mapping variables?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can we create multiple integration service on single repository?
