What will happen if we have a filter transformation used in
a mapping and in the filter condition we specify 1. Yes
nothing else, only the number 1. In other words, assuming we
have 10 rows coming to this filter transformation as an
input, how many rows will be output by this transformation
when we have only 1 in the filter condition?
Answer Posted / sudha
As 1 represent TRUE condition the filter will return all
the rows that pass through it without any filtration.
here all 10 rows will be the output and by default filter
condition is 1.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is the maplet?
How can one identify whether mapping is correct or not without connecting session?
Please let me know how to make encryption and decryption with example?
what are the Methods For Creating Reusable Transformations?
Explain what is informatica metadata and where is it stored?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the scenario which compels informatica server to reject files?
what is SDLC way of code development?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is Data Caches size?
tell me about your project functionality
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a predefined event?
How you know when to use a static cache and dynamic cache in lookup transformation?