By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
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 |
What is a taget load order?
How to elaborate powercenter integration service?
What is a joiner transformation?
What is powercenter on grid?
what r the transformations that r not involved in mapplet?
How will u pas the data with out debugger?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
how to load dimension table and fact table. plz tell me the steps.
What is sql query override? When did u use sql query override?
Explain what are the different types of transformation available in informatica.
Is snow flake or star schema used? If star schema means why?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer