How to extract original records at one target & Duplicate
records at one target?
Answer Posted / shankar
First Pipeline:
SQ--Sort---Tgt1
Second Pipeline:
SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.
Use target load plan while u run the session...
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
Difference between Target-based loading and constraint-based loading?
What is depict expression change?
tell me the rules and responsblites in our project(my project is development)
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
explain one complex mapping with logic? sales project?
What are the restrictions of union transformation?
What is informatica worklet?
Different qualification between a related rotate toward the sky and isolates look upward?
Under which circumstances, informatica server creates reject files?
What happens when a session fails and you click on recover?
Clarify the utilization of aggregator cache record?
Where is metadata stored?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the way to execute pl/sql script using informatica mapping?