Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kiran ghatage
You can go through the following solution from Informatica Marketplace. You will also find over 400 mapping samples and many other useful tools on the same website.https://community.informatica.com/solutions/developer_client_self_join_using_joiner
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is target load order?
tell me the rules and responsblites in our project(my project is development)
What is target designer and target load order?
How do you change a non-reusable transformation to reusable transformation?
What is DR strategy for Informatica project?
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 fact table?
What are mapplets?
What are the new features of informatica 9.x at the developer level?
During the running session, output files are created by informatica server. Enlist few of them.
What is confirmed fact in dataware housing?
What are the differences between source qualifier and joiner transformation?
How to implement security measures using repository manager?
what is the -ve test case in your project.
how tokens will generate?
