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
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 |
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 |
What is Data Caches size?
Write the unconnected lookup syntax and how to return more than one column.
What are the differences between joiner transformation and source qualifier transformation?
what is the difference between mapplet & stored procedure?
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?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
What are the challenges of Dataware housing in the future?
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?
select count(1) from emp? what is the o/p?
What are the parts of Informatica Server?
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?