By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
Answer Posted / aruna
Use another Filter Xn with the reverse condition and get the discared rows.
There is no such property in Filter Xn to "Forward Rejected Rows" as mentioned above in one of the answers.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What do you mean by filter transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the benefit of session partitioning?
How can we use mapping variables in informatica?
In informatica workflow manager, how many repositories can be created?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the different types of repositories created using informatica?
What does refresh system mean, and what are its distinctive choice?
what is the hint? how to use it to reduce the query processing in program?
What is persistent lookup cache?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
In development project what is the process to follow for an etl developer from day1
list out all the transformations which use cache?