What is the difference between a router and a filter
transformation?
Answer / sbvp
router filter
1.mutlipule conditions here 1.single condition here
2.send to multiple targets 2.single target
3.it captures the rejected records 3.it doesnot capture
in default output rejected records
group.
4.this is active t/r 4. this is also activet/r
| Is This Answer Correct ? | 18 Yes | 1 No |
what is upstream and downstream transformation?
How does the session recovery work.
Explain the informatica workflow?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what are challenges that you faced in testing? give solution to it?
how you will maintain version?
How are the sources and targets definitions imported in informatica designer?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
without dynamic lookup transformation how to insert new rows and update existing rows?
How to load duplicate records in to a target table which has a primary key?
i have two source data there is no pk,fk how to join the two sources