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

Explain the etl program with few examples.

638


what is index?how it can work in informatica

1695


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

893


What does role playing dimension mean?

714


what is INFORMATICA TESTING process

1943






Performance tuning( what you did in performance tuning)

1594


Is it possible to use a client with different version than that of its Informatica server?

739


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

1763


What are the settings that you use to configure the joiner transformation?

687


What is a snowflake schema?

655


What is the fact table?

682


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2383


What is the need of etl tools?

714


While migrating the data from one environment to another environment how would you manage the connections?

723


Enlist some properties of sessions.

729