By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 45065 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
u can not pass the rows if condition is not satisfy .
| Is This Answer Correct ? | 80 Yes | 4 No |
Answer / nikunj
Don't use filter transformation.
Router transformation is a better option in this scenario.
| Is This Answer Correct ? | 50 Yes | 5 No |
Answer / satishreddy
write opposite condition what mentioned in filter
transformation1 in another filter t.f and pass the rows
which are not satisfying filter1 but satisy 2 in to target2
| Is This Answer Correct ? | 29 Yes | 7 No |
Answer / 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 |
Answer / priya
Well You can Use Router iif you need rejected rows along
with satisfied rows otherwis you just give the condition
for filter tx as you want it in your target table.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / nagaraj
If you need default rows you dont go for filter
Better you go to router t/f.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / kumarn
Better to use Router t/r.In router the unmatched records
will goes to default group.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / yogesh
Use Router tranformation. All the rows which doesnot match
the group (filter condition) will be routed to default
group. Connect default group ports to 2nd target.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / prasad.bluesky
it is possible to see the rejected rows after filter
transformation solution is create an empty file and write
that file name in $rejectfile option in session then after
run your session see your created file it contains rejected
rows.
| Is This Answer Correct ? | 10 Yes | 6 No |
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
What are the Differences between connected and unconnected lookup?
how to connect two or more table with single source qualifier?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
How to update records in Target, without using Update Strategy?
What is batch and describe about types of batches?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
How to eliminate duplicate records in informatica mapping? Explain with an example....
Can we override a native sql query within informatica?
Teradata 
