i have 2 mapings for this 2 mapings i want use only one
lookupt/r how?
Answer Posted / lvpr
If the lookup condition is same for both mappings, then
make lookup t/r as reusable t/r
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What is enterprise data warehousing?
What are the different types of transformation available in informatica.
What are the differences between oltp and olap?
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 partition the Session?
Explain the difference between mapping parameter and mapping variable?
What is dimensional table? Explain the different dimensions.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Write the prerequisite tasks to achieve the session partition?
Please let me know how to make Data masking in informatica..
Can we create a Integration service without a Repository service and vice versa?
What are connected or unconnected transformations?
What are the differences between source qualifier and joiner transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use