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 |
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
How many number of sessions can one group in batches?
what is diff b/t sorter t/r and agg have the option sorter property...
how to get flatfile containg 10 records half records one target another half another target
How does a rank transform differ from aggregator transform functions max and min?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
what is the difference between Informatica 7.1 and Abinitio?
What are the types of maping wizards that r to be provided in Informatica?
Explain the flow of data in Iinformatica?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?