how can we use sorter transformation in joins?
Answer Posted / m
To improve the perfomance we have to check the button "sorted input" ,
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the use of code page?
Please let me know how to make encryption and decryption with example?
What are junk dimensions?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is data caches/ index caches?
How to update or delete the rows in a target, which do not have key fields?
How to differentiate between the active and passive transformations?
Design time, run time. If you don't create parameter what will happen
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 implement security measures using repository manager?
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is $$$$?
How can we improve session performance in aggregator transformation?
difference between informatica 8.1.1 and 8.6
What is a pre-defined event and user-defined event?