Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 19748 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Which transformation should u need while using the cobol sources as source defintions?
Briefly describe lookup transformation?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
why we use informatica in our project?
What is update override?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to improve the performance of Aggregate transformation?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
what is workflow varible
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Why do you use Mapping Parameter and mapping variable?
Teradata 
