In router source is a boy age 20 I given 3 conditions in
router a>20, a<=20, a=20 which one exit first?
Answer Posted / naveen
I assume ques is not clear and correct.
To answer ur question router will execute first which group
is defined first and next in order.
if you ques is age 20 will go in which group then ans is
a<=20 and a=20
both satisfied the condition, hence records will go in both
group.
correct me if am wrong.
Regards,
Naveen
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
Explain the different dimensions.
How many types of sessions are there in informatica.please explain them?
Explian the Process of deployment groups in informatica
what is informatica metadata?
Partition, what happens if the specified key range is shorter and longer
While migrating the data from one environment to another environment how would you manage the connections?
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 tokens will generate?
Why sorter is an active transformation?
Briefly define a session task?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the reusable transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Reusable transformation and shortcut differences