Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 22247 Views
- I also Faced
- E-Mail Answers
Answer Posted / davan
sq-->sort--exp--riuder--tg1--tg2
In exp V_flag=iif(empno=p_empno,v_flag+1,1)--variable port
p_empno=empno--variable port
0_flag=v_flag--output port
In rouder o_flag>1 one target,default one target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the format of informatica objects in a repository?
What is domain and gateway node?
tell me 5 session failure in real time how can you solve that in your project?
How many ways a relational source definition can be updated and what are they?
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 are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the different lookup cache(s)?
what is SDLC way of code development?
What is a code page?
Why update strategy and union transformations are active? Explain with examples.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the tasks that can be performed using sq?
Explain how to import oracle sequence into informatica?
can we override a native sql query within informatica? Where do we do it?
