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 |
How are parameters defined in informatica?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
How do you handle decimal places while importing a flatfile into informatica?
without using emailtask how will send a mail from informatica?
What is a parameter When and where do you them when does the value will be created
Why we select the table which has minimum number of records as Master table in joiner?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
How to handle changing source file counts in a mapping?
what is the flat file partition and where have to specify it
what is threshold error in informatica?