What is Factless fact table ???
Answer Posted / aneesh
A factless fact table is fact table that does not contain
fact.They contain only dimesional keys and it captures
events that happen only at information level but not
included in the calculations level.just an information about
an event that happen over a period.
Refer the below site to get a better idea
dwhlaureate.blogspot.in/2012/08/factless-fact-table.html
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write the different tools in the workflow manager?
What are junk dimensions?
How do you use reject loader.
Differentiate between a repository server and a powerhouse?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is an Integration service in Informatica?
What are the types of lookup transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain transaction control transformation in informatica
What happens when a session fails and you click on recover?
Write the unconnected lookup syntax and how to return more than one column.
Enlist the tasks for which source qualifier transformation is used.
lookup transformation with screenshots
What is workflow manager?
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