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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / pavan
THE FILTER CONDITION IS 0 THE SESSION WILL BE FAIL
THE FILTER CONDITION IS NON ZERO MEANS LIKE 1,2,3....IS TRUE THEN IT PROCESS ALL THE ROWS WITH OUT FILTERING ANY DATA
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / susanta
Can u plz tell me wat will happen if I give -3...
| Is This Answer Correct ? | 1 Yes | 2 No |
can we use bulk loading when we use look in mapping
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Enlist some properties of sessions.
Explain what are the different versions of informatica?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
how to get the first row without using rank t/r?
What is joiner transformation in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
What is limitations of truncate and load option