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

Answer Posted / satishreddy

write opposite condition what mentioned in filter
transformation1 in another filter t.f and pass the rows
which are not satisfying filter1 but satisy 2 in to target2

Is This Answer Correct ?    29 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where to store informatica rejected data? How to extract the informatica rejected data?

607


lookup transformation with screenshots

3559


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


How to extract the informatica rejected data?

757


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5836






Explain how to import oracle sequence into informatica?

594


Differentiate between a repository server and a powerhouse?

583


Explain why we use partitioning the session in informatica?

617


What is sorter transformation?

587


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7683


Can we get 1st record through Informatica(without sequence number).

993


Mention few advantages of router transformation over filter transformation.

642


How do you load first and last records into target table?

672


How does a rank transform differ from aggregator transform functions max and min?

677


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1652