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
- 48921 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 have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
When do you use mapping parameters? (In which transformations)
How can u stop a batch?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
Difference between session variables and workflow variables?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Explain the aggregator transformation?
diffrence between command task and control task
Teradata 
