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
- 48884 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / brahmareddy
filter transformation can't captured the rejected
files.rejected files are not appeared in session log or
rejected files
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sandeepbabu
in router transformation:Each row will be input for router transformation.
IF Row is TRue:for Uesr defined group condtion the data passes to the next transformation or target table,
IF Row is Flase:Uesr defined group condtion data will be passes to default group in router transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajesh
Hi, We can do this in two ways.
By using Filter transformation and By using router transformation.
By using filter transformation take two filter transformations and take two targets one for given condition and another for unsatisfied condition.
By using Router Transformation create one new group and give the condition take two targets and create pipeline between router trans and target1 and default group to target2.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abidu
Connect the ports of the filter transformation to the
second target table and enable the 'FORWARD REJECTED ROWS'
in the properties of the filter transformation. the
rejected rows will be forwarded to this table.
pls let meknow if i m wrong anywhere.
| Is This Answer Correct ? | 13 Yes | 17 No |
If we are using an aggregator but forget to mention the group by port .what will be the output??
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
can we import source table without using source qualifier? if yes then how? if no then why?
What is a filter transformation and why it is an active one?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How might one distinguish in the case of mapping is right or not without associating session?
What is active and passive transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Teradata 
