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
- 20037 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 |
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
Can anyone briefly describe abt audit table loading?
Why should we use star schema in datawarehouse design?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
how u know when to use a static cache and dynamic cache in lookup transformation.
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Which is the t/r that builts only single cache memory?
How to recover the standalone session?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
How to use procedural logic inside infromatica?
Teradata 
