By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 45067 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 |
can we use cartesian join in informatica
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
what is session parameters?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Differentiate between sessions and batches?
why we use materialized view over view?
how do u fnd the duplicate rows and how to delete the duplicate rows?
have u done any performance tuning? how u ll do?
Teradata 
