Interested to Buy Any Domain ? << Click Here >> for more details...
Why we use partitioning the session in informatica?
- 2 Answers
- 14126 Views
- I also Faced
- E-Mail Answers
Answer Posted / honey
The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the use of source qualifier?
Can we create two repositories on same database instance in oracle?
How will the document be delivered to me?
How we can create indexes after completing the loan process?
What is meant by LDAP users?
Enlist the tasks for which source qualifier transformation is used.
How can we handle two sessions in informatica?
what is the size of your data warehousing?
differences between service based and product based?
How many ways a relational source definition can be updated and what are they?
Differentiate between a repository server and a powerhouse?
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
How to do unit testing in informatica? How to load data in informatica ?
What are the designer tools for creating transformations?
What is the need for an etl tool?
