Answer Posted / ibrar ahmad
1). In filter we can give condition that has to be satisfy
else rows will get rejected where else router can replace
multiple filter and there is a default group in the router
which collect all the row which failed to satisfy the
condition in diffeent group in the router.
2). filter connected to a single target table where as
router
concted to multiple targets tables
3). Filter is active where as router can be active and
passive
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is rank index in rank transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the difference between Active and Passive transformation?
Enterprise data warehouse your projects phase by phase explain?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Can informatica load heterogeneous targets from heterogeneous sources?
What is an aggregator transformation?
How do you migrate data from one environment to another?
COM components can be used in Informatica
How do you use reject loader.
Mention a few design and development best practices for informatica?
How to elaborate powercenter integration service?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is target designer and target load order?