Interested to Buy Any Domain ? << Click Here >> for more details...
what is the monster dimension plz give me one example
- 2 Answers
- 9615 Views
- EDS, I also Faced
- E-Mail Answers
Answer Posted / pooja
Monster dimensions require special handling and advanced
planning, especially when you’re dealing with rapidly
changing monster dimensions. Rapidly changing dimensions
(i.e., dimensions whose content changes as a result of
input errors or changes over time that you’re recording in
place) aren’t too much of a challenge when the dimensions
are small. However, monster dimensions consume large
amounts of maintenance time and CPU cycles because of their
size, so you need to plan carefully when you’re dealing
with them. Let’s explore two different methods for managing
rapidly changing monster dimensions: first, splitting the
dimension, and second, creating a set of non-overlapping
value ranges for each rapidly changing attribute and then
creating rows that include all possible range combinations.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the status code in stored procedure transformation?
How will the document be delivered to me?
draw informatica architecture 8.6 ?
What is decode in informatica?
What is informatica metadata and where is it stored?
complex mapping ur project u r invlve can u explain and give real time example give me ?
EXL informatica Questions
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 workflow manager?
Where can we find the throughput option in informatica?
How can you generate reports in informatica?
wat are deployement groups in informatica, how it will be used for developers
Parameter and variable differences
