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
- 48357 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 |
HOW DO YOU PARFORM INCREMENTAL LAOD ?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
How will u pas the data with out debugger?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
lookup transformation with screenshots
What is critical mapping?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
what is unique constraint error ?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Is it possible to revert a global repository to local one and why?
What is event and what are the tasks related to it?
Teradata 
