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 are the settings that you use to configure the joiner transformation?
Could you explain what is enterprise data warehouse?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
If we are using an aggregator but forget to mention the group by port .what will be the output??
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Can we call a stored procedure from a unix script which is run using command task
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
Can i create a lookup table without cache.
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it