Filter condition at workflow level & filter condition at mapping level .
Which will get preference or which will work.

Answers were Sorted based on User's Feedback



Filter condition at workflow level & filter condition at mapping level . Which will get prefe..

Answer / me

Informatica server will ignore the filter at mapping level and
will execute only session level.

Is This Answer Correct ?    7 Yes 2 No

Filter condition at workflow level & filter condition at mapping level . Which will get prefe..

Answer / sandeep

Session level filters will always override mapping level filter conditions.
So Session filter will take the precedence.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is Data Caches size?

0 Answers   Informatica,


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  


What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,


what is the difference between mapplet & stored procedure?

1 Answers  


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,


What are the challenges of Dataware housing in the future?

2 Answers   HP,


Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,


select count(1) from emp? what is the o/p?

5 Answers   TCS,


What are the parts of Informatica Server?

1 Answers   Cognizant,


What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,


Categories