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
- 47675 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 |
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
how we do performence tuning in informatica
can we use cartesian join in informatica
What are the new features of the server manager in the informatica 5.0?
if i have a delimited file as source so how can we seperate this file into three diff targets?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
How to view and Generate Metadata Reports?
What is meant by LDAP users?
Teradata 
