What is the difference between a router and a filter
transformation?
Answer Posted / 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 |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is rank transform?
What are the informatica performance improvement tips
What are the differences between joiner transformation and source qualifier transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
differences between service based and product based?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
As union transformation gives UNION ALL output, how you will get the UNION output?
my source is junk data how will u remove that junk data by using unix please any one replay me
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is meant by a domain?
Define update strategy?
What are the different transaction levels available in transaction control transformation?