what is the need of session partitioning... how it is
useful in real time
Answer Posted / sbvprasad
while need means it increase the perfomance of the session.
. like
hash partitioning.
roundrobin.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to do unit testing in informatica?
What is an Integration service in Informatica?
Mention few advantages of router transformation over filter transformation.
How to use procedural logic inside infromatica?
What are the types of caches in lookup?
What does reusable transformation mean?
How to generate sequence numbers without using the sequence generator transformation?
Briefly describe lookup transformation?
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.
What is workflow? What are the components of the 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
What are the performance considerations when working with aggregator transformation?
What does cheating measurement mean?
How can repository reports be accessed without sql or other transformations?
How to generate sequence numbers?