Interested to Buy Any Domain ? << Click Here >> for more details...
By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 47796 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 |
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
What is a grid in Informatica?
How many repositories can be created in informatica?
Label in Informatica. How to remove existing Label.
How i can upload the MainFrame source For Informatica ?
How you load distinct records into one target and duplicate records into another target?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
What r the type of indexes u generally used in informatica?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
What are the designer tools for creating transformations?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Teradata 
