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 |
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
Mention few advantages of router transformation over filter transformation.
What is Cognos script editor?
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?
In how many ways we can create ports?
Briefly define reusable transformation?
When the informatica server marks that a batch is failed?
Which are the different editions of informatica powercenter that are available?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
Can we use parameters of parameter file in presession command
 Informatica Checkpoints