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 |
Tell me about informatica architecture.
Roles and Responsibilties of Informatica Production Support Member?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
What is the difference between Power Centre and Power Mart?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is mapping parameter?
how to remove staging area
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs