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

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


Mention few advantages of router transformation over filter transformation.

0 Answers  


What is Cognos script editor?

0 Answers   Cognizant,


source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,


In how many ways we can create ports?

0 Answers  






Briefly define reusable transformation?

0 Answers  


When the informatica server marks that a batch is failed?

2 Answers  


Which are the different editions of informatica powercenter that are available?

0 Answers  


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,


Can we use parameters of parameter file in presession command

1 Answers   Wipro,


 Informatica Checkpoints

0 Answers   DELL,


Categories