,if we have single SQ in flow and we have router in which it
has two group and we want to join these two groups with
joiner ?is it possible?
Answer Posted / sree
It is not possible to connect output groups of router with
joiner transformation.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
What does command task mean?
what are the Methods For Creating Reusable Transformations?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is standalone command task?
Is it possible to define a single node as a Gateway node as well as worker node?
What are mapplets? How is it different from a Reusable Transformation?
Explain the types of transformations?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
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 conditions needed to improve the performance of informatica aggregator transformation?
How might you approve all mappings in the archive all the while?
How can we delete duplicate rows from flat files?
Is stop and abort are same in informatica?