Filter condition at workflow level & filter condition at mapping level .
Which will get preference or which will work.
Answer Posted / me
Informatica server will ignore the filter at mapping level and
will execute only session level.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is an expression transformation in informatica?
What is a sequence generator transformation?
How to load data in informatica ?
What are the different types of olap? Give an example?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can you define user defied event?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Differentiate between source qualifier and filter transformation?
Which is the t/r that builts only single cache memory?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is mapping debugger?
where to store informatica rejected data?