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 / schwab

Yes Ur right
0 represent FALSE and
all NON-Zero numbers are TRUE.

Answer to above question is all 10 rows will be inserted.

Is This Answer Correct ?    21 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6094


What is depict expression change?

623


How to generate sequence numbers?

622


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1941


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2300






Explain pushdown optimization and types in informatica

672


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


How would you copy the content of one repository to another repository?

563


How many dimensions are there in informatica?

633


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1735


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1703


Briefly define a session task?

595


explain about unit testing? in real time?

1674


What is aggregate cache in aggregator transformation?

637


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1880