Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11209 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / suresh
Fact:
Fact represents business measure.
Fact table:
A fact table is the primary table in a dimensional model where the numerical performance measurements of the are stored.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the cumulative sum and moving sum?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is a repository manager?
What is DR strategy for Informatica project?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Different sorts of metadata that stores in the storage facility?
How to generate sequence numbers using expression transformation?
What does cheating measurement mean?
Describe the impact of several join conditions and join order in a joiner transformation?
Differentiate between Load Manager and DTM?
Explain the types of transformations?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
tell me 5 session failure in real time how can you solve that in your project?
