Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandhya
a dimension table is one which contain master data
all the data in the fact is related to the data in the
dimension.
| Is This Answer Correct ? | 31 Yes | 3 No |
Post New Answer View All Answers
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to update or delete the rows in a target, which do not have key fields?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are different types of transformations available in informatica?
How to create a non-reusable instance of reusable transformations?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
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
scenario where i can use only concurrent execution of workflow.
What is the different lookup cache(s)?
How to differentiate between the active and passive transformations?
How to elaborate powercenter integration service?
Explain sql transformation in script mode examples in informatica
Slowly changing dimensions, types and where will you use them
Suppose we do not group by on any ports of the aggregator what will be the output?
