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 load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Can we write to_date(three arguments) ? Will it work ? Advance thanks
What is a difference between complete, stop and abort?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
what type of transformation is not supported by mapplets?
How are indexes created after completing the load process?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
Write the unconnected lookup syntax?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What are the new features of the server manager in the informatica 5.0?