By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 45061 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
Answer Posted / nagarjuna redd
Use router transformation to load the rejected data.
Connect output ports(i.e: condition satisfied records) to
the one target table and connect default ports(not
satisfied records) to the another target
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Where is metadata stored?
What is a difference between complete, stop and abort?
what is unit testing?tell me proceedure
What are the different options available for update strategy?
write a query to retrieve the latest records from the table sorted by version(scd)
In which transformation you cannot drag ports into it?
Define enterprise data warehousing?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
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
What is domain in terms of informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is update strategy transform?
What is exclusive and normal mode for repository services?
Enlist the advantages of informatica.
