Don't use filter transformation. Router transformation is a better

By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?

Question Posted / nikunj

Answer Posted / nikunj

Don't use filter transformation.

Router transformation is a better option in this scenario.

Is This Answer Correct ?

50 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is mapping debugger?

1063

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1175

What is option by which we can run all the sessions in a batch simultaneously?

1185

Reusable transformation and shortcut differences

1878

Have you worked with/created Parameter file

1708

How to load last n records of file into target table - informatica

1130

What is sq transformation?

1223

Do you find any difficulty while working with flat files as source and target?

1146

What is powercenter on grid?

1221

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1094

can u any challenge your project?

2080

Implementation methodology

1758

What do you mean by worklet?

1112

What is informatica etl tool?

1052

What are the different transaction levels available in transaction control transformation?

1269