if i have a file having record sal=10000,and when use router
with two groups having condition sal>5000 in one
group,sal>7000 in other group.and if two groups connected to
two targets.in which target sal=10000 will go?
Answer Posted / chegu
Both records satisfying the conditions go to target
like the emp table has 14 rows,in router we pass the emp data and create 2 groups as sal_1=sal>1100 and sal_2=sal>1500 and then connect to two target tables run workflow,we get 18 records as output satisfying first and second conditions.
Thank you
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a joiner transformation?
what is the -ve test case in your project.
How are indexes created after completing the load process?
What are the differences between source qualifier and joiner transformation?
What do think which one is the better joiner or look up?
Define filter transformation?
How to partition the Session?
What can we do to improve the performance of informatica aggregator transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to create the source and target database connections in server manager?
How to improve the performance of a session using sorter transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
What is a standalone command task?
Which means the first record should come as last record and last record should come as first record and load into the target file?