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 |
Filter transformation in the condition one of the data is NULL would the record be dropped.
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?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
why do we go for update strategy tr in SCD rather using the session properties?
What is critical mapping?
Describe expression transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Which version configuration tool used in ur project?
Differentiate between Load Manager and DTM?
What are differences between Informatica 7.1 and 6.1
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?