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 |
How to join three sources using joiner? Explain though mapping flow.
how to run the batch using pmcmd command
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Which transformation should u need while using the cobol sources as source defintions?
What is Session and Batches?
What are the tasks that source qualifier performs?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
Roles and Responsibilties of Informatica Production Support Member?
How to update a particular record in target with out running whole workflow?
what is the diff b/w target load plan and cbl?
What is diff joiner and lookup
what is flat file override?