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 is degenerated dimention table?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
What is powercenter on grid?
How i can upload the MainFrame source For Informatica ?
what is system requirement(SR) & business requirement(BR)?
How do you load only null records into target? Explain through mapping flow.
What is the Difference between SetVariable and setmaxvariable in informatica?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the performance considerations when working with aggregator transformation?
Define filter transformation?