Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / seetharam
The dimension keys which are directly cming from the oltp
system with out any associated dimension to the fact table
.These are called degenerate dim or line item dimensions
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 the command used to run a batch?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to create Target definition for flat files?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
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.
Define the various join types of joiner transformation?
If informatica has its scheduler why using third party scheduler?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is session task and command task?
scenario where i can use only concurrent execution of workflow.
What is primary and backup node?
What is different between the data warehouse and data mart?
Whats there in global repository
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
